今天在公司做项目,使用 sqlyog 导入sql脚本文件时报错,打开sqlyog.err.txt后,发现报错如下:
Error occured at:2019-05-05 10:49:35
Line no.:185
Error Code: 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 '' at line 3Query:
CREATE PROCEDURE `usercenter`.`setNubeProc`()
BEGIN
DECLARE v_nubeNumber varchar(20)
于是使用notepad++打开sql脚本文件,根据提示,出错的位置在第185行,而且是语法错误,截取报错部分如下:
DROP PROCEDURE IF EXISTS `usercenter`.`setNubeProc`;
CREATE PROCEDURE `usercenter`.`setNubeProc`()
BEGIN
DECLARE v_nubeNumber varchar(20);
DECLARE v_uid varchar(64) default '';
declare count int default 0;
DECLARE userinfo_cur CURSOR for select uid from usercenter.user_info where nube_number is null and mobile is not n