mysql - 创建函数时出现语法错误

Question

我正在尝试创建一个如下所示的函数:

CREATE FUNCTION TitleToFileName(title varchar(200)) RETURNS varchar(200)
  BEGIN
    set title = REPLACE(title,":"," ");
    set title=REPLACE(title,"/"," ");
    set title=REPLACE(title,"_"," ");
    RETURN title;
  END

MySQL 显示错误:

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

我尝试使用 ' 代替 "和 @title 代替 title ，但没​​有成功。

Answer 1

• 您需要将 Delimiter 重新定义为其他内容(例如:$$)，而不是 (;)。
• 此外，作为一项安全措施，请检查同名函数是否已存在(DROP FUNCTION IF EXISTS)
• 最后，将DELIMITER重新定义为;

尝试:

DELIMITER $$
DROP FUNCTION IF EXISTS `TitleToFileName`$$
CREATE FUNCTION TitleToFileName(title varchar(200)) RETURNS varchar(200)
  BEGIN
    set title = REPLACE(title,":"," ");
    set title=REPLACE(title,"/"," ");
    set title=REPLACE(title,"_"," ");
    RETURN title;
  END $$
DELIMITER ;