- stop slave;
- drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
- reset master;
- reset slave;
- drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
- start slave;
- create table t1 (n int not null auto_increment primary key);
- insert into t1 values(NULL);
- insert into t1 values(2);
- select n from t1;
- n
- 1
- 2
- drop table t1;