我写了个触发器: CREATE TRIGGER bbs1 AFTER UPDATE ON bbs_members FOR EACH ROW update bbs_members set extcredits5=NEW.credits/10 where uid=NEW.uid; 可是我再update的时候就会报错:Can't update table 'bbs_members' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
建议给出你的 create table 语句,这样别人可以直接调试。
还不如写两个sql 操作两个表
错误已经说得很明白了: Can't update table 'bbs_members' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.而且根据你的要求,完全可以把处理A和处理B放在一个事务里,来达到更新A时连带地更新B。
CREATE TRIGGER bbs1 AFTER UPDATE ON bbs_members FOR EACH ROW update bbs_members set extcredits5=NEW.credits/10 where uid=NEW.uid;
可是我再update的时候就会报错:Can't update table 'bbs_members' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
Can't update table 'bbs_members' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.而且根据你的要求,完全可以把处理A和处理B放在一个事务里,来达到更新A时连带地更新B。