1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
include/master-slave.inc [connection master] CREATE TEMPORARY TABLE t1(c1 INTEGER); CREATE TABLE t2(c1 INTEGER); CREATE TABLE t1(c1 INTEGER); INSERT INTO t1 VALUES(1), (2); INSERT INTO t2 VALUES(1), (2); SELECT * FROM t1; c1 1 2 SELECT * FROM t2; c1 1 2 TRUNCATE t1; TRUNCATE t2; SELECT * FROM t1; c1 1 2 SELECT * FROM t2; c1 DROP TABLE t1; DROP TABLE t2; include/rpl_end.inc |