sdept) values(‘95005’, ‘刘云’, ‘女’, 18, ‘CS’)
insert into course(cno, cname,credit,cpno) values(‘1’, ‘数据库...chinesegrade as zong from studentgrad
select year(birth) as birthday from student where sdept=’CS’
由于建立表的时候生日的数据类型不是...datetime所以不能查到(基本语法如此,birth是datetime的)
select sname+’年龄为’+str(sage)+’岁’ from student—-此处注意多了一个c
select...*,sc.* from student,sc where (student.sno =* sc.sno) –(部分版本的不支持这句查询)
select student....sname,sage from student where sno in (select sno from sc where cno=(select cno from course where cname=’数据库