mysq 游标哪里错了？感觉没错

Question

delimiter $
create function youbiao()
begin

declare a varchar(20);
declare flag int default false;
declare d int;
# 声明一个游标

declare mycursor cursor for select age,dogname from dog;# 游标一定要在变量后申明

声明一个游标的终止条件

declare continue handler for not found set flag=true; # set flag是一个变量用作判断
open mycursor; #打开mycursor这个游标
while !flag do
fetch mycursor into d,a ;
select d,a;
end while;
close mycursor；
end $
delimiter ;

     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 'begin 

Answer 1

delimiter $
create function youbiao()
begin
declare a varchar(20);
declare flag int default false;
declare d int;
# 声明一个游标
declare mycursor cursor for select age,dogname from dog;# 游标一定要在变量后申明

声明一个游标的终止条件

declare continue handler for not found set flag=true; # set flag是一个变量用作判断
open mycursor; #打开mycursor这个游标
while !flag do
fetch mycursor into d,a ;
select d,a;
end while;
close mycursor；
end $
delimiter ;

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 'begin