1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
CREATE TABLE t1 (a int primary key);
insert into t1 values (1),(2),(3),(4),(5),(6);
select * from t1 order by a;
delete from t1 where a=2;
select * from t1 order by a;
delete from t1 where a=4;
select * from t1 order by a;
delete from t1 where a=6;
select * from t1 order by a;
drop table t1;
CREATE TABLE t2 (a int primary key, b varchar(100));
insert into t2 values (1,"Beaker"), (2, "Cricket");
select * from t2;
delete from t2 where b="Cricket";
select * from t2;
delete from t2 where a=1;
select * from t2;
drop table t2;
|