blob: 944f701d765d6e28238117ea0b4c13bfabc882f9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
source include/master-slave.inc;
connection master;
drop table if exists test;
CREATE TABLE test (name varchar(64), age smallint(3));
INSERT INTO test SET name='Andy', age=31;
INSERT test SET name='Jacob', age=2;
INSERT into test SET name='Caleb', age=1;
ALTER TABLE test ADD id int(8) ZEROFILL AUTO_INCREMENT PRIMARY KEY;
@r/rpl000005.result select * from test;
connection slave;
sleep 0.5;
@r/rpl000005.result select * from test;
|