Заполнить БД данными

[shachenkovan]

• [x] Написать SQL-запросы для вставки данных в таблицы при помощи INSERT

[shachenkovan]

NSERT INTO kabinet (nomer) VALUES ('112'); INSERT INTO kabinet (nomer) VALUES ('241'); INSERT INTO kabinet (nomer) VALUES ('452');

INSERT INTO sotrudnik (imja, fam, otch, ur_dostupa) VALUES ('Иванов', 'Петр', 'Алексеевич', '1'); INSERT INTO sotrudnik (imja, fam, otch, ur_dostupa) VALUES ('Смирнов', 'Андрей', 'Игоревич', '0'); INSERT INTO sotrudnik (imja, fam, otch, ur_dostupa) VALUES ('Васильев', 'Анатолий', 'Георгиевич', '0');

INSERT INTO system_block (firma, model) VALUES ('SB', 'D56K4'); INSERT INTO system_block (firma, model) VALUES ('PCSB', 'L4LR32'); INSERT INTO system_block (firma, model) VALUES ('SB', 'P66LFJD');

INSERT INTO monitor (firma, model) VALUES ('HP', 'FJG546'); INSERT INTO monitor (firma, model) VALUES ('Apple', 'FDKFMC pro'); INSERT INTO monitor (firma, model) VALUES ('Samsung', 'KMV34KD4');

INSERT INTO keyboard (firma, model) VALUES ('Acer', 'NV38573'); INSERT INTO keyboard (firma, model) VALUES ('HP', 'SFCK3M3'); INSERT INTO keyboard (firma, model) VALUES ('LogiTech', 'X493X');

INSERT INTO mouse (firma, model) VALUES ('A4Tech', 'XM34589'); INSERT INTO mouse (firma, model) VALUES ('LogiTech', '759DM9JS'); INSERT INTO mouse (firma, model) VALUES ('HP', 'KS438A');

INSERT INTO printer (firma, model) VALUES ('Acer', '8DJC8K3'); INSERT INTO printer (firma, model) VALUES ('Canon', 'Z236HF8'); INSERT INTO printer (firma, model) VALUES ('Artec', 'N538DJS');

INSERT INTO router (firma, model) VALUES ('Cisco', '97KSK2J'); INSERT INTO router (firma, model) VALUES ('MicroTik', 'CN35U3D'); INSERT INTO router (firma, model) VALUES ('Keenetic', '684MXJE');

INSERT INTO workplace (id_sotr, id_kab, id_systblock, id_mon, id_kb, id_mouse, id_printer, id_router) VALUES ('3', '1', '1', '2', '3', '2', '1', '1'); INSERT INTO workplace (id_sotr, id_kab, id_systblock, id_mon, id_kb, id_mouse, id_printer, id_router) VALUES ('2', '2', '3', '3', '1', '3', '3', '2'); INSERT INTO workplace (id_sotr, id_kab, id_systblock, id_mon, id_kb, id_mouse, id_printer, id_router) VALUES ('1', '3', '2', '1', '2', '1', '2', '3');