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;

原文：http://www.cnblogs.com/zrp2013/p/3522308.html