银点 2018年03月01日
触发器,语法错,谁能帮我看看在哪里有错
mysql> create trigger tr_generate_id before insert on hospital for each
-> begin
-> set hospital_id = (select replace(uuid(),'-',''));
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 'begin
set hospital_id = (select replace(uuid(),'-',''))' at line 2
mysql>
...全文
453 点赞 收藏 4
写回复
4 条回复

还没有回复,快来抢沙发~

发动态
发帖子
MySQL
创建于2007-09-28

2.4w+

社区成员

5.5w+

社区内容

MySQL相关内容讨论专区
社区公告
暂无公告