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;
8
CREATE TABLE t (a int, b int, c int, key(b));
10
CREATE TABLE t (a int, b int, c int);
11
INSERT INTO t VALUES (1,2,4);
12
INSERT INTO t VALUES (4,3,4);
16
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
19
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
21
CREATE TABLE t (a int, b int, c int, key(b));
22
ALTER TABLE t DISABLE KEYS;
23
INSERT INTO t VALUES (1,2,4);
24
INSERT INTO t VALUES (4,3,4);