daan.txt

一些简单的sql语句的测试系统

2.create table zouyihuan(studentname char(36),studentno char(54)); 
3.insert into zouyihuan values('zouyihuan','05044144'); 
4.alter table  zouyihuan add studentage char(7);
5.insert into zouyihuan(studentno,studentname,studentage) select sno,sname,sage from s1;  
6.update zouyihuan set studentage='22'where studentno='05044144';
7.alter table zouyihuan alter column studentage int;
8.update zouyihuan set studentage=studentage+4 where studentno='05044144';
9.select sum(studentage)from zouyihuan;
10.select cname,grade from zouyihuan,c0,sc01 where studentno=sc01.sno and sc01.cno=c0.cno and studentname='d123';
11.delete from sc01 where sno=(select studentno from zouyihuan where studentname='d123'); 
12.delete from zouyihuan where studentname='d123';
13.alter table d123 drop zouyihuan;
14.drop table d123;
15.create view zouyihuanh(XM,KM,CJ)AS select sname,cname,grade from s1, c0,sc01 where s1.sno=sc01.sno and sc01.cno=c0.cno;