CREATE TABLE mydb.user(
id INT UNSIGNED PRIMARY KEY AITO_INCREMENT COMMENT'用户 id',
username VARCHAR(20) UNIQUE NOT NULL COMMENT'用户名',
mobile CHAR(11) NOT NULL COMMENT '手机号码',
gender ENUM('男','女','保密') NOT NULL COMMENT'性别',
reg_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT'注册时间',
level TINYINT UNSIGNED NOT NULL COMMENT'会员等级',
DEFAULT CHARSET=utf8;
INSERT INTO mydb.user VALUES(
NULL,'小明',
'12311111111','男',
'2018-01-01 11:11:11',1
);