2 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7 create table t1(n int auto_increment primary key, s char(10));
8 insert into t1 values (2,'old');
9 insert into t1 values(NULL,'new');
10 insert into t1 values(NULL,'new');
11 select * from t1 order by n;
15 delete from t1 where n = 2;
18 create table t2(n int);
20 insert into t1 values(NULL,'new');
22 insert into t1 values(NULL,'new');
24 delete from t1 where n=4;
26 select * from t1 order by n;