感觉有语法错误。set new.v_teacherID=10这个地方 是什么意思你的表里有new.v_teacherID吗? mysql> create trigger manager_test before insert on manager
-> for each row
-> update manager set id=10
-> where name like '王%';Query OK, 0 rows affected (0.02 sec) 晕你仔细看清楚 你少了个before insert 你仔细看下错误 This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'这说明你很可能之前在这个表上已经建立一个有同样功能的触发器了 或者其它什么原因