数据库表查询练习

建表

create table stu(
id int primary key auto_increment,
name varchar(255),
sex varchar(255),
hometown varchar(255),
age int,
class varchar(255),
card varchar(255)
)

#插入数据
insert into stu values(1,‘王昭君’,‘女’,‘北京’,20,‘1班’,3525455855554);
insert into stu values(10,‘妲己’,‘女’,‘广东’,26,‘2班’,3525455855554);
insert into stu values(11,‘李白’,‘男’,‘河南’,21,‘1班’,null);
insert into stu values(12,‘刘备’,‘男’,‘四川’,32,‘2班’,35254558);
insert into stu values(2,‘诸葛亮’,‘男’,‘上海’,18,‘2班’,3525455855554);
insert into stu values(3,‘张飞’,‘男’,‘南京’,24,‘3班’,3525455855554);
insert into stu values(4,‘白起’,‘男’,‘北京’,22,‘4班’,3525455855554);
insert into stu values(5,‘大乔’,‘女’,‘天津’,19,‘3班’,3525455855554);
insert into stu values(6,‘孙尚香’,‘女’,‘河北’,18,‘1班’,3525455855554);
insert into stu values(7,‘百里守策’,‘男’,‘山西’,20,‘2班’,3525455855554);
insert into stu values(8,‘小乔’,‘女’,null,15,‘4班’,null );
insert into stu values(9,‘百里守约’,‘男’,‘上海’,21,‘1班’,null);