全部博文
-
编辑 删除
mysql存储过程 实例
DELIMITER | CREATE TRIGGER insert00 AFTER INSERT ON guangli999ll.adad FOR EACH ROW BEGIN INSERT INTO guangli999lk.adad SELECT * FROM guangli999ll.adad WHERE id>(select max(id) from guangli999lk.adad); END; | DELIMITER ; DELIMITER | CREATE TRIGGER tg_sync_delete AFTER DELETE ON adad FOR EACH ROW BEGIN DELETE FROM adad2 WHERE adad2.id=old.id; END; | DELIMITER ; DELIMITER | CREATE TRIGGER tg_sync_update AFTER UPDATE ON adad FOR EACH ROW BEGIN DELETE FROM adad2 WHERE adad2.id=OLD.id; INSE
