"MySQL语法错误"在创建函数时 [英] "MySQL syntax error" while creating a function

问题描述

#1064-您的SQL语法有错误；请在第3行的创建功能TavoliLiberi(dataora DATETIME)返回BOOL BEGIN DECLARE prese"之前，查看与MySQL服务器版本相对应的手册以使用正确的语法在此功能中:

"#1064 - 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 'CREATE FUNCTION TavoliLiberi (dataora DATETIME) RETURN BOOL BEGIN DECLARE prese' at line 3" in this function:

DELIMITER $

DROP FUNCTION IF EXISTS TavoliLiberi;

CREATE FUNCTION TavoliLiberi (dataora DATETIME) RETURN BOOL
BEGIN
DECLARE presenti BOOL;
DECLARE numPrenotazioni INT;
DECLARE numTavoli INT;

SELECT COUNT(*) INTO numPrenotazioni
FROM Prenotazioni
WHERE DataOra = dataora;

SELECT COUNT(*) INTO numTavoli
FROM Tavoli;

IF (numPrenotazioni < numTavoli) THEN
    SET presenti = TRUE;
ELSE
    SET presenti = FALSE;
END IF;

RETURN presenti;
END $

DELIMITER ;

怎么了?

推荐答案

好像您的分隔符首选项设置在错误的位置.请尝试以下操作:

Looks like your delimiter preference is set in the wrong place. Try the following:

DROP FUNCTION IF EXISTS TavoliLiberi;

DELIMITER $

CREATE FUNCTION TavoliLiberi (dataora DATETIME) RETURN BOOL
....
....

这篇关于"MySQL语法错误"在创建函数时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！