触发器，语法错，谁能帮我看看在哪里有错

[银点]

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>

[银点]

我知道了，要在提示符下 delimiter // 写完一段后 再delimiter ;

[ceshizxcvbnm]

恕在下才疏学浅，没看出来~

[zjcxc]

引用 1 楼 silverpot 的回复:

我知道了，要在提示符下 delimiter // 写完一段后 再delimiter ;

正解

[toward_south]

；冲突，自己定义一个结束符号