1
CREATE TABLE t1 (a int primary key);
2
insert into t1 values (1),(2),(3),(4),(5),(6);
3
select * from t1 order by a;
11
delete from t1 where a=2;
12
select * from t1 order by a;
19
delete from t1 where a=4;
20
select * from t1 order by a;
26
delete from t1 where a=6;
27
select * from t1 order by a;
33
CREATE TABLE t2 (a int primary key, b varchar(100));
34
insert into t2 values (1,"Beaker"), (2, "Cricket");
39
delete from t2 where b="Cricket";
43
delete from t2 where a=1;