本文介绍了创建MySQL触发器的SQL语法错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我尝试创建触发器
CREATE TRIGGER `aster_users2` after update ON `aster_users` FOR EACH ROW BEGIN update event set flag=1 where id=1; END;但遇到下一个错误
错误1064(42000):您的SQL语法有错误;查看与您的MySQL服务器版本相对应的手册以获取正确的语法,以在第6行的"end"附近使用
ERROR 1064 (42000): 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 6
有解决这个问题的建议吗?
have suggestion to solve this problem ?
推荐答案尝试从语句中删除分号.
Try removing the semi-colons from your statements.
如果您想保留分号,
DELIMITER $$ CREATE TRIGGER `aster_users2` after update ON `aster_users` FOR EACH ROW BEGIN update event set flag=1 where id=1; END$$ DELIMITER ;更多推荐
创建MySQL触发器的SQL语法错误
发布评论