1include/master-slave.inc
2[connection master]
3CREATE TEMPORARY TABLE t1(c1 INTEGER);
4CREATE TABLE t2(c1 INTEGER);
5connection slave;
6CREATE TABLE t1(c1 INTEGER);
7INSERT INTO t1 VALUES(1), (2);
8INSERT INTO t2 VALUES(1), (2);
9SELECT * FROM t1;
10c1
111
122
13SELECT * FROM t2;
14c1
151
162
17connection master;
18TRUNCATE t1;
19TRUNCATE t2;
20connection slave;
21SELECT * FROM t1;
22c1
231
242
25SELECT * FROM t2;
26c1
27DROP TABLE t1;
28connection master;
29DROP TABLE t2;
30include/rpl_end.inc
31