\g SHOW DATABASES

\g CREATE DATABASE STD

\g use STD

\g CREATE TABLE ITEM (quantity int(11) NOT NULL, measure varchar(100) NOT NULL, price int(11) NOT NULL, last_delivery datetime NOT NULL, name text NOT NULL, item_number int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT);
\g CREATE TABLE HELPER (item_number int(11) NOT NULL, inn INT NOT NULL);
\g CREATE TABLE LIST (receipt_date date NOT NULL, shipping_date date NOT NULL, item_quantity int(11) NOT NULL, note_id int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT, inn int(11) NOT NULL REFERENCES ITEM(item_number));
\g CREATE TABLE PROVIDER (address text NOT NULL, phone varchar(20) NOT NULL, inn int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT);


\g SHOW TABLES

\g DESCRIBE ITEM



\g INSERT INTO ITEM (quantity, measure, price, last_delivery, name) VALUES (10,'литры',100,'2019-09-10 14:25','Кола');
\g INSERT INTO ITEM (quantity, measure, price, last_delivery, name) VALUES (25,'литры',149,'2019-09-10 14:50','Пепси');
\g INSERT INTO ITEM (quantity, measure, price, last_delivery, name) VALUES (43,'килограммы',550,'2019-09-10 14:10','Свинина');
\g INSERT INTO ITEM (quantity, measure, price, last_delivery, name) VALUES (55,'килограммы',150,'2019-09-10 12:10','Пельмени');
\g INSERT INTO ITEM (quantity, measure, price, last_delivery, name) VALUES (120,'килограммы',2000,'2019-09-10 10:10','Печенье');
\g INSERT INTO ITEM (quantity, measure, price, last_delivery, name) VALUES (47,'тонны',10000,'2019-09-10 10:10','Соль');



\g INSERT INTO HELPER (item_number, inn) VALUES (1,1);
\g INSERT INTO HELPER (item_number, inn) VALUES (2,2);
\g INSERT INTO HELPER (item_number, inn) VALUES (3,3);
\g INSERT INTO HELPER (item_number, inn) VALUES (4,4);
\g INSERT INTO HELPER (item_number, inn) VALUES (5,5);
\g INSERT INTO HELPER (item_number, inn) VALUES (6,6);



\g INSERT INTO LIST (receipt_date, shipping_date, item_quantity, inn) VALUES ('2019-09-10 14:22', '2019-09-10 11:33', 444, 2);
\g INSERT INTO LIST (receipt_date, shipping_date, item_quantity, inn) VALUES ('2019-09-10 14:22', '2019-09-10 11:33', 211,  3);
\g INSERT INTO LIST (receipt_date, shipping_date, item_quantity, inn) VALUES ('2019-09-10 11:44', '2019-09-10 17:25', 11,  1);
\g INSERT INTO LIST (receipt_date, shipping_date, item_quantity, inn) VALUES ('2019-09-10 06:55', '2019-09-10 14:22', 22,  4);
\g INSERT INTO LIST (receipt_date, shipping_date, item_quantity, inn) VALUES ('2019-09-10 14:25', '2019-09-10 15:41', 33,  5);
\g INSERT INTO LIST (receipt_date, shipping_date, item_quantity, inn) VALUES ('2019-09-10 14:11', '2019-09-10 13:25', 556,  6);



\g INSERT INTO PROVIDER (address, phone) VALUES ('Волгоград','658741');
\g INSERT INTO PROVIDER (address, phone) VALUES ('Москва','150220');
\g INSERT INTO PROVIDER (address, phone) VALUES ('Новосибирс','14220');
\g INSERT INTO PROVIDER (address, phone) VALUES ('Тула','2524');
\g INSERT INTO PROVIDER (address, phone) VALUES ('Санкт-Петербург','25077');



\g DELETE FROM HELPER WHERE inn = 1474; - удаление стоо

\g UPDATE PROVIDER SET address = 'Новосибирск' WHERE address = 'Новосибирс';




\g DROP DATABASE STD

\g SELECT * FROM HELPER;





\g ALTER TABLE ITEM ADD TEST int(11) NOT NULL - добавить стобцы

\g ALTER TABLE ITEM MODIFY TEST varchar(100);   - редактировать стобцы

\g ALTER TABLE ITEM DROP COLUMN TEST   - удалить стобцы








\g SELECT * FROM ITEM;
\g SELECT * FROM ITEM WHERE measure = 'килограммы';
\g SELECT * FROM ITEM WHERE measure = 'килограммы' ORDER BY item_number DESC;
\g SELECT * FROM PROVIDER WHERE address = 'Новосибирск' AND  phone = 14220;