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);
9
insert into t1 values (NULL),(NULL),(NULL);
16
Server_id Host Port Rpl_recovery_rank Master_id
20
create table t2(id int auto_increment primary key, created datetime);
22
insert into t2 set created=now();
26
create table t3 like t2;
27
create temporary table t4 like t2;
28
create table t5 select * from t4;
35
t3 CREATE TABLE `t3` (
36
`id` int(11) NOT NULL AUTO_INCREMENT,
37
`created` datetime DEFAULT NULL,
39
) ENGINE=MyISAM DEFAULT CHARSET=latin1
42
t5 CREATE TABLE `t5` (
43
`id` int(11) NOT NULL DEFAULT '0',
44
`created` datetime DEFAULT NULL
45
) ENGINE=MyISAM DEFAULT CHARSET=latin1