因为mysql存储过程导致sql文件执行出错

今天在公司做项目，使用 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