sql 执行错误

[yiyebaofu2]

执行 database.sql 的时候创建function错误
mysql版本5.7

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 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 'RETURN FUN_SEQ_CURRENT_VALUE(SEQ)' at line 1
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 'END' at line 1
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
ERROR 1193 (HY000): Unknown system variable 'VALUE'
ERROR 1327 (42000): Undeclared variable: VALUE
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 'RETURN VALUE' at line 1
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 'END' at line 1
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 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 'RETURN FUN_SEQ_CURRENT_VALUE(SEQ)' at line 1
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 'END' at line 1
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 4
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 'END' at line 1
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
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 'END' at line 1

[leslie52]

两个办法：

1. 用Navicat for MySQL这个工具 导入脚本
2. 脚本中 创建函数处加转义符处理

[zhaodp]

对创建函数处做如下改动，即可顺利导入：

delimiter //

CREATE FUNCTION FUN_SEQ(SEQ VARCHAR(50)) RETURNS BIGINT(20)
BEGIN
UPDATE SEQ_TABLE
SET CURRENT_VALUE = CURRENT_VALUE + INCREMENT
WHERE SEQ_NAME=SEQ;
RETURN FUN_SEQ_CURRENT_VALUE(SEQ);
END //

CREATE FUNCTION FUN_SEQ_CURRENT_VALUE(SEQ VARCHAR(50)) RETURNS BIGINT(20)
BEGIN
DECLARE VALUE INTEGER;
SET VALUE=0;
SELECT CURRENT_VALUE INTO VALUE
FROM SEQ_TABLE
WHERE SEQ_NAME=SEQ;
RETURN VALUE;
END //

CREATE FUNCTION FUN_SEQ_SET_VALUE(SEQ VARCHAR(50), VALUE INTEGER) RETURNS BIGINT(20)
BEGIN
UPDATE SEQ_TABLE
SET CURRENT_VALUE=VALUE
WHERE SEQ_NAME=SEQ;
RETURN FUN_SEQ_CURRENT_VALUE(SEQ);
END //

CREATE FUNCTION FUN_NOW()
RETURNS DATETIME
BEGIN
RETURN now();
END //

-- 时间函数

CREATE FUNCTION FUN_DATE_ADD(STR_DATE VARCHAR(10), STR_INTERVAL INTEGER) RETURNS DATE
BEGIN
RETURN date_add(STR_DATE, INTERVAL STR_INTERVAL DAY);
END //

delimiter ;