CREATE PROCEDURE curdemo()
begin
declare var_id varchar(32);
declare var_number varchar(32);
DECLARE var_model VARCHAR(32);
declare rs cursor for select id,number from t_device_lending;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET Done = 1;
open rs;
fetch next from rs into var_id,var_number;
REPEAT
IF NOT Done THEN
select model_number into var_model from t_device_info where number = var_number;
update t_device_lending_copy set model_number = var_model where id = var_id;
END IF;
FETCH NEXT FROM rs INTO id,number;
UNTIL Done END REPEAT;
/* 关闭游标 */
CLOSE rs;
end
报的错是“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 'declare var_id varchar(32)' at line 3”
我对了一下5.7.10的官方手册。declare的语法应该是正确的,怎么会报这种错?求大神解释。