SELECt * FROM student WHERe ssex = '男';
2、查询李白和杜甫的年纪
SELECt sname,sage FROM student WHERe sname='李白' OR sname='杜甫';
3、查询年纪在25~30之间的个数SELECt COUNT(sage) FROM student WHERe sage BETWEEN 25 AND 30;
4、查询李白的作品名称、名句和年纪
SELECt w.wwork,s.sasess,c.sage FROM student1 w,student c,student2 s WHERe w.wid = s.wid AND s.sid = c.sid AND sname='李白';
5、 新增名人表中的一位作者王维，年龄25，性别是男
INSERT INTO student VALUES(7,'王维',25,'男')；
