2.4w+
社区成员
5.5w+
社区内容
- 主页
触发器，语法错，谁能帮我看看在哪里有错
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>
-> 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>
...全文
还没有回复，快来抢沙发～