MySQL创建function时出错
写了个function，结果报错，说是declare的错误，看代码应该不会有什么declare的错误啊，请大家帮忙。

SQL code

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 default 0;->
declare finished int default 0;
------解决方案--------------------

引用

太粗心了 ，没写integer类型

------解决方案--------------------
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;
这种错误就是告诉你，你的SQL语法错误了，并且通过use near '...'来标示你的SQL语法错在哪个地方。
------解决方案--------------------
declare finished int default 0;
声明finished未指定数据类型的原因导致的。