SQL创建触发器

更新:

CREATE TRIGGER `r_users_1` AFTER UPDATE ON `users`
FOR EACH ROW update `wxusers` set status=NEW.status where wxusers.uid = new.id;

删除触发器:drop trigger r_users_1;

时不我待,不负韶华!立刻行动!不吃学习的苦就会吃生活的苦!
原文地址:https://www.cnblogs.com/zrp2013/p/3522308.html