##插入记录 ~~~ insert into user(NAME,GENDER,SID,LEVEL,CLASS,ACHIEVEMENT,REMAKRS) values("安牡丹",2,"350213199106258506","2","6",85,"爱好音乐、美术"); insert into user(NAME,GENDER,SID,LEVEL,CLASS,ACHIEVEMENT,REMAKRS) values("刘婷",2,"110235198609120622","2","2",95,""); insert into user(NAME,GENDER,SID,LEVEL,CLASS,ACHIEVEMENT,REMAKRS) values("姚瑶",2,"110258198508282882","2","8",90,""); insert into user(NAME,GENDER,SID,LEVEL,CLASS,ACHIEVEMENT,REMAKRS) values("王明",1,"110623198202162462","2","4",90,"爱好篮球"); insert into user(NAME,GENDER,SID,LEVEL,CLASS,ACHIEVEMENT,REMAKRS) values("孙丽",2,"126123198305241624","1","6",91,""); insert into user(NAME,GENDER,SID,LEVEL,CLASS,ACHIEVEMENT,REMAKRS) values("冯敏",2,"133621198206252137","2","1",99,"爱好运动"); insert into user(NAME,GENDER,SID,LEVEL,CLASS,ACHIEVEMENT,REMAKRS) values("高原",1,"133621198206252137","2","1",90,""); insert into user(NAME,GENDER,SID,LEVEL,CLASS,ACHIEVEMENT,REMAKRS) values("张寒",1,"135236198508265971","1","5",89,""); insert into user(NAME,GENDER,SID,LEVEL,CLASS,ACHIEVEMENT,REMAKRS) values("张红",1,"140235198310232314","2","3",88,""); ~~~ 把2年级的学生信息都插入到level2表中 先创建level2表，字段，数据类型必须跟user表一致。 ~~~ create table level2 ( ID INT(3) NOT NULL AUTO_INCREMENT, NAME CHAR(16) NOT NULL, GENDER INT(1) NOT NULL, SID CHAR(18) NOT NULL, LEVEL CHAR(1) NOT NULL, CLASS CHAR(1) NOT NULL, ACHIEVEMENT INT(3) NOT NULL, REMAKRS VARCHAR(1000), PRIMARY KEY(ID) ); ~~~ 开始插入数据 ~~~ insert into level2 select * from user where level=2; ~~~