
复制CREATETABLE `student` ( `id` int(11) NOTNULL AUTO_INCREMENT,记次 `name` char(20) NOTNULL, `age` tinyint(2) NOTNULLDEFAULT0, PRIMARYKEY (`id`), KEY `index_name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 mysql> insert student values(1,zhangsan,20); mysql> insert student values(2,lisi,21); mysql> insert student values(3,wangwu,22); 1.2.3.4.5.6.7.8.9.10.11.