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;

posted @ 2014-01-16 12:29  不负韶华668  阅读(185)  评论(0编辑  收藏  举报