mysql error 1442_mySQL 1442 错误

信息如下 ERROR 1442 (HY000): Can't update table 'event1' in stored function/trigger becau

se it is already used by statement which invoked this stored function/trigger.

刚开始触发器定义如下

create trigger event_trigger BEFORE INSERT ON event1

FOR EACH ROW  UPDATE event1

SET  NEW.event_time =CURRENT_TIMESTAMP();

一般在定义触发器时 如果对本表做更新 应写成如下

drop trigger  if exists event_trigger ;

DELIMITER |

create trigger event_trigger BEFORE INSERT ON event1

FOR EACH ROW

SET  NEW.event_time =CURRENT_TIMESTAMP();

|

DELIMITER ;

不用写成全局的update 表名

可以参考国外的一篇文章