mysql> create procedure bugs.p1()
-> begin
-> set @a=5;
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 '' at line 3原因:
默认存储以“;”为结束符,导致存储异常结束;
mysql>delimiter // -->存储最后以 // 结束
PS:如此设置后,数据库中度语句/数据快都要以“//”才识别为结束;如果需要改成";"为结束符号时,可:
mysql>delimiter ; -->存储最后以 ; 结束