
复制CREATETABLE `staff` ( `id` BIGINT ( 11 ) AUTO_INCREMENT COMMENT 主键id,看遍
`id_card` VARCHAR ( 20 ) NOTNULL COMMENT 身份证号码, `name` VARCHAR ( 64 ) NOTNULL COMMENT 姓名, `age` INT ( 4 ) NOTNULL COMMENT 年龄, `city` VARCHAR ( 64 ) NOTNULL COMMENT 城市, PRIMARYKEY ( `id`), INDEX idx_city ( `city` ) ) ENGINE = INNODB COMMENT 员工表; 1.2.3.4.5.6.7.8.9.