Mysql触发器

-- 创建表table1DROP TABLE IF EXISTS table1;CREATE TABLE table1(    table1_id VARCHAR(10));-- 创建表table2DROP TABLE IF EXISTS table2;CREATE TABLE table2(    table2_id VARCHAR(10));-- 创建触发器:insert_trigger_table1,增加table1表记录后自动将记录增加到table2表中DROP TRIGGER IF EXISTS insert_trigger_table1;DELIMITER $CREATE TRIGGER insert_trigger_table1 AFTER INSERT ON table1FOR EACH ROWBEGININSERT INTO table2(table2_id) VALUE(new.table1_id);END$DELIMITER;-- 测试 INSERT INTO table1(table1_id) VALUES('110');SELECT * FROM table1;SELECT * FROM table2;-- 创建触发器:delete_trigger_table1,删除table1表记录后自动将table2表中对应的记录删去DROP TRIGGER IF EXISTS delete_trigger_table1;DELIMITER $CREATE TRIGGER delete_trigger_table1AFTER DELETE ON table1FOR EACH ROWBEGIN      DELETE FROM table2 WHERE table2_id=old.table1_id;END$DELIMITER;-- 测试 DELETE FROM table1 WHERE table1_id='110';SELECT * FROM table1;SELECT * FROM table2;

-- 创建触发器:update_trigger_table1,修改table1表记录后自动将table2表中对应的记录修改DROP TRIGGER IF EXISTS update_trigger_table1;DELIMITER $CREATE TRIGGER update_trigger_table1AFTER UPDATE ON table1FOR EACH ROWBEGIN        UPDATE table2 SET table2_id=new.table1_id ;END$DELIMITER;-- 测试 UPDATE  table1 SET table1_id='120';SELECT * FROM table1;SELECT * FROM table2;