[Err] 1442 - Can't update table 'user_account' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
super_junior 提问于:2018-07-16
0 0

mysql更新出错:

[Err] 1442 - Can't update table 'user_account' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.

触发器:

DELIMITER $

create trigger user_account_tri
before UPDATE ON user_account FOR EACH ROW

  update user_account set NEW.insert_t = NOW() where id=NEW.ID;
end

DELIMITER ;

??

  • 所有回答
暂时还没有回答,我来回答