
复制CREATETABLE `employees` ( `id` int(11) NOTNULL AUTO_INCREMENT,工作给解 `name` varchar(24) NOTNULLDEFAULT COMMENT 姓名, `age` int(20) NOTNULLDEFAULT0 COMMENT 年龄, `position` varchar(20) NOTNULLDEFAULT COMMENT 职位, `hire_time` timestampNOTNULLDEFAULTCURRENT_TIMESTAMPONUPDATECURRENT_TIMESTAMP COMMENT 入职时间, PRIMARYKEY (`id`), KEY `idx_name_age_position` (`name`,`age`,`position`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=员工表; insertinto employees(name,age,position,hire_time) values(LiLei, 22, manager, NOW()) insertinto employees(name,age,position,hire_time) values(HanMeimei, 23, dev, NOW()) insertinto employees(name,age,position,hire_time) values(Lucy, 23, dev, NOW()) 1.2.3.4.5.6.7.8.9.10.11.12.





