求助:mysql恢复当中提示错误#1064
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;
提示的错误是:
错误
SQL 查询:
CREATE DEFINER = 'root'@ 'localhost' FUNCTION `dayChinaNameOfWeek` (
curDay DATE
) RETURNS varchar( 10 ) CHARSET gb2312 NOT DETERMINISTICCONTAINS SQLSQL 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 'varchar(10)' at line 8
本数据备份文件,应该是由用户数据中备份下来的,我使用phpmyadmin恢复的时候,有如上提示,因为原始数据库不是我做的,MYSQL也不太熟,希望大家可以帮看看什么问题