Mysql多表查询（案例1）

表结构

select * from celebrity where ssex=男;

select c.sname from summary as s inner join celebrity as c on s.sid=c.sid inner join works as w 
on s.wid = w.wid where w.wwork=静夜思;

3.查询李白和杜甫的年纪

select sname,sage from celebrity where sname in (李白,杜甫);

4.查询名人表中的男女人数

select count(*),ssex from celebrity group by ssex;

5.查询白居易写的作品名称和对应的名句

select c.sname,w.wwork,s.sassess from summary as s inner join celebrity as c on s.sid=c.sid
inner join works as w on s.wid=w.wid where c.sname=白居易;

6.查询年纪在25-30岁之间的个数

select count(*) from celebrity where sage between 25 and 30;

7.查询名人表中年纪最小的两条信息

select * from celebrity order by sage limit 0,2;

8.查询李白的作品名称，名句和年纪

select w.wwork,s.sassess,c.sage from summary as s inner join works as w on s.wid=w.wid inner 
join celebrity as c on s.sid=c.sid where sname=李白;

9.将作品为望岳的朝代修改为北宋

update works set wdynasty=北宋 where wwork=望岳;

insert into celebrity values(7,王维,25,男);