Shared note

practical 1 mysql> CREATE TABLE client ( -> client_number CHAR(6) PRIMARY KEY, -> name VARCHAR(20) NOT NULL, -> city VARCHAR(50) NOT NULL, -> pin_number INT, -> mobile CHAR(10) -> ); Query OK, 0 rows affected (0.07 sec)

practical 2