MySQL 存储过程 BEGIN/END 语句抛出错误

Question

我正在尝试运行存储过程并在调试时遇到实际问题。

我已经尝试删除所有内容以尝试追踪问题，甚至到这里我都遇到了错误:

DROP PROCEDURE IF EXISTS sp_transpose_tickets;
CREATE PROCEDURE sp_transpose_tickets ()
BEGIN
select 1;
END

错误是:

> Error : 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 2
> 
> Error : 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 1

这是在我的本地机器上，在 root 用户下，所以所有权限都被授予，我正在运行 mySQL 5.5.20。

Answer 1

您应该定义分隔符:

DELIMITER $$

DROP PROCEDURE IF EXISTS sp_transpose_tickets $$
CREATE PROCEDURE sp_transpose_tickets ()
BEGIN
    select 1;
END$$

DELIMITER ;