写了个function,结果报错,说是declare的错误,看代码应该不会有什么declare的错误啊,请大家帮忙。
delimiter $$
create function pbi_db.get_category_list() returns varchar(255)
begin
declare finished default 0;
declare category_list varchar(255);
declare name varchar(50);
declare category_list_cur cursor for select name from category;
declare continue handler for not found set finished=1; open category_list_cur; get_name_list: loop
fetch category_list_cur into name;
if finished then
leave get_name_list;
end if
set category_list = CONCAT(category_list,",",name);
end loop get_name_list; close category_list_cur; return SUBSTR(list,3);
end
$$
delimiter ;
报错:mysql> source /home/hadoop/quinton/procPractice/get_category_list.sql
ERROR 1064 (42000): 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 'default 0;
declare category_list varchar(255);
declare name varchar(50);
decl' at line 3
delimiter $$
create function pbi_db.get_category_list() returns varchar(255)
begin
declare finished default 0;
declare category_list varchar(255);
declare name varchar(50);
declare category_list_cur cursor for select name from category;
declare continue handler for not found set finished=1; open category_list_cur; get_name_list: loop
fetch category_list_cur into name;
if finished then
leave get_name_list;
end if
set category_list = CONCAT(category_list,",",name);
end loop get_name_list; close category_list_cur; return SUBSTR(list,3);
end
$$
delimiter ;
报错:mysql> source /home/hadoop/quinton/procPractice/get_category_list.sql
ERROR 1064 (42000): 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 'default 0;
declare category_list varchar(255);
declare name varchar(50);
decl' at line 3
declare finished int default 0;
这种错误就是告诉你,你的SQL语法错误了,并且通过use near '...'来标示你的SQL语法错在哪个地方。
声明finished未指定数据类型的原因导致的。