1
include/master-slave.inc
5
CREATE TABLE t1 (a INT, b LONG) ENGINE=InnoDB;
6
INSERT INTO t1 VALUES (1,1), (2,2);
9
include/diff_tables.inc [master:t1, slave:t1]
10
==== Test using a table with delete triggers ====
13
CREATE TABLE t2 (a INT, b LONG) ENGINE=InnoDB;
14
CREATE TRIGGER trg1 BEFORE DELETE ON t1 FOR EACH ROW SET @count := @count + 1;
17
include/diff_tables.inc [master:t2, slave:t2]
21
CREATE TABLE t1 (a INT, b LONG) ENGINE=InnoDB;
22
INSERT INTO t1 VALUES (1,1), (2,2);
25
include/diff_tables.inc [master:t1, slave:t1]
26
==== Test using a table with delete triggers ====
29
CREATE TABLE t2 (a INT, b LONG) ENGINE=InnoDB;
30
CREATE TRIGGER trg1 BEFORE DELETE ON t1 FOR EACH ROW SET @count := @count + 1;
33
include/diff_tables.inc [master:t2, slave:t2]