delimiter //
CREATE DEFINER = 'root'@'localhost' FUNCTION `dayChinaNameOfWeek`(curDay DATE)
RETURNS varchar(10) CHARSET gb2312
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
DECLARE cName varchar(10);
SELECT substring(_UTF8'日一二三四五六',dayofweek(curDay),1) INTO cName;
RETURN cName;
END;
//
delimiter ;
CREATE DEFINER = 'root'@'localhost' FUNCTION `dayChinaNameOfWeek`(curDay DATE)
RETURNS varchar(10) CHARSET gb2312
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
DECLARE cName varchar(10);
SELECT substring(_UTF8'日一二三四五六',dayofweek(curDay),1) INTO cName;
RETURN cName;
END;
//
delimiter ;
delimiter $$
CREATE DEFINER = 'root'@'localhost' FUNCTION `dayChinaNameOfWeek`(curDay DATE)
RETURNS varchar(10) CHARSET gb2312
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
DECLARE cName varchar(10);
SELECT substring(_UTF8'日一二三四五六',dayofweek(curDay),1) INTO cName;
RETURN cName;
END$$
delimiter ;
您的 SQL 查询可能有错。如果可能的话,以下会列出 MySQL 服务器的错误输出,这可能对您解决问题有一定的帮助作用。ERROR: 未知的标点符号字符串 @ 12
STR: //
SQL:
delimiter //
CREATE DEFINER = 'root'@'localhost' FUNCTION `dayChinaNameOfWeek`(curDay DATE)
RETURNS varchar(10) CHARSET gb2312
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
DECLARE cName varchar(10);
SQL 查询: delimiter // CREATE DEFINER = 'root'@'localhost' FUNCTION `dayChinaNameOfWeek`(curDay DATE) RETURNS varchar(10) CHARSET gb2312 NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT '' BEGIN DECLARE cName varchar(10); 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 'delimiter //
CREATE DEFINER = 'root'@'localhost' FUNCTION `dayChinaNameOfWeek`' at line 1
我想问一下,MYSQL 备份的SQL文件中FUNCTION,不能直接导入,需要我一条条的手工输入?MYSQL确实不熟,问得不对,或不准确,请各位原谅
会不会是MYSQL的版本问题?我的是MYSQL5.0.2.7
从5.5备份出来的SQL(SP、UDF),导入5.6中就有问题,要对文件进行手工处理