复制CREATE TABLE `staff` ( `id` BIGINT ( 11 ) AUTO_INCREMENT COMMENT 主键id,看遍 `id_card` VARCHAR ( 20 ) NOT NULL COMMENT 身份证号码, `name` VARCHAR ( 64 ) NOT NULL COMMENT 姓名, `age` INT ( 4 ) NOT NULL COMMENT 年龄, `city` VARCHAR ( 64 ) NOT NULL COMMENT 城市, PRIMARY KEY ( `id`), INDEX idx_city ( `city` ) ) ENGINE = INNODB COMMENT 员工表; 1.2.3.4.5.6.7.8.9. |
喜欢
讨厌