1 include/master-slave.inc
3 DROP PROCEDURE IF EXISTS test.p1;
4 DROP TABLE IF EXISTS test.t2;
5 CREATE TABLE test.t1 (a INT,PRIMARY KEY(a));
6 CREATE TABLE test.t2 (a INT,PRIMARY KEY(a));
7 INSERT INTO test.t1 VALUES(1),(2);
8 CREATE PROCEDURE test.p1()
10 SELECT SQL_CALC_FOUND_ROWS * FROM test.t1 LIMIT 1;
11 INSERT INTO test.t2 VALUES(FOUND_ROWS());
14 < ---- Master selects-- >
15 -------------------------
19 SELECT * FROM test.t2;
23 < ---- Slave selects-- >
24 ------------------------
25 SELECT * FROM test.t2;
28 DROP PROCEDURE IF EXISTS test.p1;
29 DROP TABLE IF EXISTS test.t1;
30 DROP TABLE IF EXISTS test.t2;