CREATE TRIGGER trigger_activity_id_delete
AFTER DELETE
ON tp_activity FOR EACH ROW
BEGIN
DELETE FROM tp_code WHERE OLD.id = tp_code.`activity_id`;
END
报错:
1 queries executed, 0 success, 1 errors, 0 warnings
查询:End
错误代码: 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 'End' at line 1
执行耗时 : 0 sec
传送时间 : 0 sec
总耗时 : 0 sec
原因:
本文探讨了在MySQL中使用触发器实现删除级联时遇到的语法错误问题,具体为在'END'关键字处出现的错误,涉及SQL语法正确性和触发器编写规范。

3万+

被折叠的 条评论
为什么被折叠?



