1
SET SESSION storage_engine=pbxt;
2
CREATE TABLE t1 (a int primary key);
3
insert into t1 values (1),(2),(3),(4),(5),(6);
4
select * from t1 order by a;
12
delete from t1 where a=2;
13
select * from t1 order by a;
20
delete from t1 where a=4;
21
select * from t1 order by a;
27
delete from t1 where a=6;
28
select * from t1 order by a;
34
CREATE TABLE t2 (a int primary key, b varchar(100));
35
insert into t2 values (1,"Beaker"), (2, "Cricket");
40
delete from t2 where b="Cricket";
44
delete from t2 where a=1;