我正在使用MySQL v5.1.36,我正在嘗試使用此代碼創建存儲函數.

DELIMITER //

CREATE FUNCTION `modx`.getSTID (x VARCHAR(255)) RETURNS INT DETERMINISTIC

BEGIN

DECLARE y INT;

SELECT id INTO y

FROM `modx`.coverage_state

WHERE `coverage_state`.name = x;

RETURN y;

END//

當進入MysqL控制臺時,我得到了這個回復.

MysqL> DELIMITER //

MysqL> CREATE FUNCTION `modx`.getSTID (x VARCHAR(255)) RETURNS INT DETERMINISTIC

-> BEGIN

-> DECLARE y INT;

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> SELECT id INTO y

-> FROM `modx`.coverage_state

-> WHERE `coverage_state`.name = x;

ERROR 1327 (42000): Undeclared variable: y

MysqL> RETURN y;

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 'RETUR

N y' at line 1

MysqL> END//

從我在網上找到的我的語法是正確的.我究竟做錯了什么？

總結

以上是生活随笔為你收集整理的mysql5建函数报1064错误,MySQL存储函数创建错误ERROR 1064和1327的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。