1include/master-slave.inc 2[connection master] 3connection master; 4DROP TRIGGER test.t2_ai; 5DROP TABLE IF EXISTS test.t1; 6DROP TABLE IF EXISTS test.t2; 7DROP TABLE IF EXISTS test.t3; 8CREATE TABLE test.t2 (value CHAR(30),domain_id INT, mailaccount_id INT, program CHAR(30),keey CHAR(30),PRIMARY KEY(domain_id)); 9CREATE TABLE test.t3 (value CHAR(30),domain_id INT, mailaccount_id INT, program CHAR(30),keey CHAR(30),PRIMARY KEY(domain_id)); 10CREATE TABLE test.t1 (id INT,domain CHAR(30),PRIMARY KEY(id)); 11CREATE TRIGGER test.t2_ai AFTER INSERT ON test.t2 FOR EACH ROW UPDATE test.t3 ms, test.t1 d SET ms.value='No' WHERE ms.domain_id = (SELECT max(id) FROM test.t1 WHERE domain='example.com') AND ms.mailaccount_id IS NULL AND ms.program='spamfilter' AND ms.keey='scan_incoming'| 12INSERT INTO test.t1 VALUES (1, 'example.com'),(2, 'mysql.com'),(3, 'earthmotherwear.com'), (4, 'yahoo.com'),(5, 'example.com'); 13SELECT * FROM test.t1 ORDER BY id; 14id domain 151 example.com 162 mysql.com 173 earthmotherwear.com 184 yahoo.com 195 example.com 20connection slave; 21SELECT * FROM test.t1 ORDER BY id; 22id domain 231 example.com 242 mysql.com 253 earthmotherwear.com 264 yahoo.com 275 example.com 28connection master; 29INSERT INTO test.t3 VALUES ('Yes', 5, NULL, 'spamfilter','scan_incoming'); 30INSERT INTO test.t3 VALUES ('Yes', 1, NULL, 'spamfilter','scan_incoming'); 31INSERT INTO test.t2 VALUES ('Yes', 1, NULL, 'spamfilter','scan_incoming'); 32select * from test.t2; 33value domain_id mailaccount_id program keey 34Yes 1 NULL spamfilter scan_incoming 35select * from test.t3; 36value domain_id mailaccount_id program keey 37No 5 NULL spamfilter scan_incoming 38Yes 1 NULL spamfilter scan_incoming 39connection slave; 40select * from test.t2; 41value domain_id mailaccount_id program keey 42Yes 1 NULL spamfilter scan_incoming 43select * from test.t3; 44value domain_id mailaccount_id program keey 45No 5 NULL spamfilter scan_incoming 46Yes 1 NULL spamfilter scan_incoming 47connection master; 48DELETE FROM test.t1 WHERE id = 1; 49SELECT * FROM test.t1 ORDER BY id; 50id domain 512 mysql.com 523 earthmotherwear.com 534 yahoo.com 545 example.com 55connection master; 56SELECT * FROM test.t1 ORDER BY id; 57id domain 582 mysql.com 593 earthmotherwear.com 604 yahoo.com 615 example.com 62connection slave; 63SELECT * FROM test.t1 ORDER BY id; 64id domain 652 mysql.com 663 earthmotherwear.com 674 yahoo.com 685 example.com 69connection master; 70DROP TRIGGER test.t2_ai; 71DROP TABLE test.t1; 72DROP TABLE test.t2; 73DROP TABLE test.t3; 74connection slave; 75include/rpl_end.inc 76