mysql-h localhost -u root -p
USE company;
mysql>CREATE TABLE tb_worker (
->id INT(11)PRIMARY KEY AUTO_INCREMENT,
->name VARCHAR(30)NOT NULL,
->sex ENUM('w','m')DEFAULT'm',
->hobby SET('football','basketball','volleyball'),
->score FLOAT(3,1)UNSIGNED,
->mobile CHAR(11)UNIQUE NOT NULL,
->entry_time DATE
->)ENGINE=MyISAM;
Query OK,0 rows affected(0.05sec)