Схемы и SQL код / Лабораторная №3 ИБД Создание записей таблиц

mysql -u root -p

USE order;
SET CHARACTER SET cp1251;

DELETE FROM products;
INSERT INTO products VALUES (1,'Jacket','7500.00','Nike, Black, Sporty, nylon, 46-48RU','1');
INSERT INTO products VALUES (2,'Iphone11','50590.00','Black,128GB','1');
INSERT INTO products VALUES (3,'Apple','23.00','Green, Poland','1');
INSERT INTO products VALUES (4,'Egg','8.00','White, first grade','1');
SELECT * FROM products;

DELETE FROM clients;
INSERT INTO clients VALUES (1,'NikeShop','+79135652833','32b, Sverdlova street, Moscow','Katerina','Sergeevna','Komkova');
INSERT INTO clients VALUES (2,'DNS','+79138652883','4, Aviamotornaya street, Kaliningrad','Vladimir','Maksimovich','Gavrikov');
INSERT INTO clients VALUES (3,'Pyaterochka','+79135952836','6, Revolutsionnaya street, Krasnodar','Dmitry','Valeryevich','Potapenko');
INSERT INTO clients VALUES (4,'Magnet','+79125652893','33а, Cable street, Togliatti','Alexander','Alexandrovich','Dushev');
SELECT * FROM clients;

DELETE FROM deals;
INSERT INTO deals VALUES (1,1,1,10,'2022-01-04 10:39:38');
INSERT INTO deals VALUES (2,2,4,20,'2023-01-04 09:49:33');
INSERT INTO deals VALUES (3,3,4,40,'2023-12-20 09:40:29');
INSERT INTO deals VALUES (4,3,3,45,'2023-01-10 13:41:05');
INSERT INTO deals VALUES (5,2,2,10,'2023-12-12 18:20:00');
INSERT INTO deals VALUES (6,1,1,15,'2022-01-04 10:39:38');
INSERT INTO deals VALUES (7,2,2,35,'2023-02-01 19:15:36');
SELECT * FROM deals;

DELETE FROM delivery;

INSERT INTO delivery VALUES (1,1,'train','CDEC courier service','900.00');
INSERT INTO delivery VALUES (2,2,'car','XNS courier service','300.00');
INSERT INTO delivery VALUES (3,3,'car','ABC courier service','250.00');
INSERT INTO delivery VALUES (4,4,'car','KTC courier service','200.00');
INSERT INTO delivery VALUES (5,5,'airplane','CDEC courier service','550.00');
INSERT INTO delivery VALUES (6,6,'train','CSE courier service','600.00');
INSERT INTO delivery VALUES (7,7,'airplane','XNS courier service','300.00');
SELECT * FROM delivery;


delete from delivery where delivery_ID>5;
SELECT * FROM delivery;