SQLize Online / PHPize Online  /  SQLtest Online

create table staff like sakila.staff; insert into staff select * from sakila.staff; create table department ( department_id int auto_increment primary key , name varchar(64) ); insert into department (name) values ('Management'),('Sales'); ; -- 1. Создание таблицы department CREATE TABLE department ( department_id INT PRIMARY KEY, department_name VARCHAR(100) NOT NULL ); -- Вставка данных в таблицу department INSERT INTO department (department_id, department_name) VALUES (1, 'Sales'), (2, 'HR'), (3, 'IT'); -- 2. Изменение таблицы staff, добавление столбца department_id ALTER TABLE staff ADD COLUMN department_id INT; -- 3. Установка внешнего ключа для столбца department_id ALTER TABLE staff ADD CONSTRAINT fk_department FOREIGN KEY (department_id) REFERENCES department(department_id); -- 4. Установка значения department_id для всех записей в staff, соответствующее отделу Sales UPDATE staff SET department_id = (SELECT department_id FROM department WHERE department_name = 'Sales'); ; select staff_id, department_id from staff;