CREATE TABLE `student` (
`stuId` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`stuName` varchar(50) NOT NULL DEFAULT '' COMMENT '姓名',
PRIMARY KEY (`stuId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='学生表';
先插入一条:insert into student(stuName) values ('张三');
insert into student(stuName) select stuName from student; 执行多次就是了