1
drop table if exists t1,t2;
2
create temporary table t1(n int not null, key(n), key(n), key(n), key(n)) engine=myisam;
3
check table t1 extended;
4
insert into t1 values (200000);
5
Table Op Msg_type Msg_text
6
test.t1 check status OK
8
CREATE TEMPORARY TABLE t1(a INT) engine=myisam;
11
Table Op Msg_type Msg_text
12
test.t1 check status OK