DELIMITER$$ CREATE TRIGGER `trTemplate` BEFORE DELETE ON `tb` FOR EACH ROW BEGIN IF old.id=1 THEN ROLLBACK; END IF; END$$
DELIMITER;
DELETE from tb WHERE id=1
DROP TRIGGER trTemplate 总是报语法错误
把出错信息一起贴出来大家看一下。 SQL code: 错误码: 1422 Explicit or implicit commit is not allowed in stored function or trigger.
Execution Time : 00:00:00:000 Transfer Time : 00:00:00:000 Total Time : 00:00:00:000
错误码: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER' at line 1
mysql 可以给触发器显式或隐式方式开始或结束事务的语句吗？ 帮我写个这种需求的触发器呵，谢了 触发器中不能有 commit; rollback 这种事务语句。类似功能的实现可以参考下贴。
