\u9002\u7528\u4e8e\u5728\u540c\u4e00\u4e2a MySQL \u5b9e\u4f8b\u4e2d\u7684\u4e0d\u540c\u6570\u636e\u5e93\u3002<\/p>\n
\u65b0\u589e\uff1a<\/p>\n
DELIMITER \/\/\nCREATE TRIGGER sync_table_insert\nAFTER INSERT ON A.table_A\nFOR EACH ROW\nBEGIN\n INSERT INTO B.table_B (column1, column2, ...)\n VALUES (NEW.column1, NEW.column2, ...);\nEND;\n\/\/\nDELIMITER ;\n<\/code><\/pre>\n\u66f4\u65b0\uff1a<\/p>\n
DELIMITER \/\/\nCREATE TRIGGER sync_table_update\nAFTER UPDATE ON A.table_A\nFOR EACH ROW\nBEGIN\n UPDATE B.table_B\n SET column1 = NEW.column1, column2 = NEW.column2, ...\n WHERE id = NEW.id;\nEND;\n\/\/\nDELIMITER ;\n<\/code><\/pre>\n\u5220\u9664\uff1a<\/p>\n
DELIMITER \/\/\nCREATE TRIGGER sync_table_delete\nAFTER DELETE ON A.table_A\nFOR EACH ROW\nBEGIN\n DELETE FROM B.table_B\n WHERE id = OLD.id;\nEND;\n\/\/\nDELIMITER ;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"