第三次课.rar

# 创建一个学生信息表 create table stuinfo ( sid int auto_increment not null primary key, sname varchar(20), ssex char(2), sage int )engine=innodb default charset=utf8; #测试数据 insert into stuinfo values(null,'张子怡','女',60); insert into stuinfo values(null,'林青霞','女',60); insert into stuinfo values(null,'汪风','女',60); insert into stuinfo values(null,'陈冠希','男',40); insert into stuinfo values(null,'谢霆锋','女',40); insert into stuinfo values(null,'张柏芝','女',40); insert into stuinfo values(null,'王菲','女,'60); select * from stuinfo;