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(255) NOT NULL ); -- Вставка записи для отдела Sales INSERT INTO department (department_id, department_name) VALUES (1, 'Sales'); -- Шаг 2: Добавление столбца department_id в таблицу staff 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: Обновление записей в таблице staff UPDATE staff SET department_id = (SELECT department_id FROM department WHERE department_name = 'Sales'); ; select staff_id, department_id from staff;