1include/master-slave.inc 2[connection master] 3create table t1 (n int auto_increment primary key); 4set insert_id = 2000; 5insert into t1 values (NULL),(NULL),(NULL); 6connection slave; 7select * from t1; 8n 92000 102001 112002 12connection master; 13show slave hosts; 14Server_id Host Port Master_id 152 127.0.0.1 9999 1 16drop table t1; 17connection slave; 18stop slave; 19include/wait_for_slave_to_stop.inc 20connection master; 21create table t2(id int auto_increment primary key, created datetime); 22SET TIME_ZONE= '+03:00'; 23set timestamp=12345; 24insert into t2 set created=now(); 25select * from t2; 26id created 271 1970-01-01 06:25:45 28create table t3 like t2; 29create temporary table t4 like t2; 30create table t5 select * from t4; 31connection slave; 32start slave; 33include/wait_for_slave_to_start.inc 34select * from t2; 35id created 361 1970-01-01 06:25:45 37show create table t3; 38Table Create Table 39t3 CREATE TABLE `t3` ( 40 `id` int(11) NOT NULL AUTO_INCREMENT, 41 `created` datetime DEFAULT NULL, 42 PRIMARY KEY (`id`) 43) ENGINE=MyISAM DEFAULT CHARSET=latin1 44show create table t5; 45Table Create Table 46t5 CREATE TABLE `t5` ( 47 `id` int(11) NOT NULL DEFAULT 0, 48 `created` datetime DEFAULT NULL 49) ENGINE=MyISAM DEFAULT CHARSET=latin1 50connection master; 51drop table t2,t3,t5; 52drop temporary table t4; 53connection slave; 54include/rpl_end.inc 55