\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 VALUES (quantity = 10, measure = 'литры', price = 100, last_delivery = '2019-09-10 14:25', name = 'Кола')

\g INSERT INTO ITEM (quantity, measure, price, last_delivery, name) VALUES (10, 'литры', 100, '2019-09-10 14:25', 'Кола')

\g DROP DATABASE STD

\g SELECT * FROM ITEM;

\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   - удалить стобцы