test.txt

来自「一个用JAVA语言实现的SQL编译器。能够迅速实现对SQL语言的解析。」· 文本 代码 · 共 33 行

create table A(Id int primary key,name Varchar(10) not null,age int
,foreign key (name) references student(xingming));

insert into A values(1,'shang',22);

insert into A values(2,'liu',23);

insert into A values(3,'wang',20);

insert into A values(4,'zou',21);

update A set name='zou' where age=20 and id=2 or age<22 and name='wang';

update A set id='4' where age=20;

update A set id='5' where name='shang';

delete from A where id=2 or age<21;

delete from A where name='shang';

select id,name from A where age>20;
 
select count(*)as total,max(age)as max1,min(age)as min1,
sum(age)as sum1,avg(age)as avg1 from A where id<4;

select * from A where age>18 order by 3 desc;

select * from A where age>18 order by age desc;

select * from A where age>18 order by name desc;

select * from A;