Edit File: rpl_alter.result
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; drop database if exists mysqltest; create database mysqltest; create table mysqltest.t1 ( n int); alter table mysqltest.t1 add m int; insert into mysqltest.t1 values (1,2); create table mysqltest.t2 (n int); insert into mysqltest.t2 values (45); rename table mysqltest.t2 to mysqltest.t3, mysqltest.t1 to mysqltest.t2; select * from mysqltest.t2; n m 1 2 select * from mysqltest.t3; n 45 drop database mysqltest;
Back to File Manager