function在mysql里总是出错_MySQL创造function时出错

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创造function时出错》,跪求各位点评，by 搞代码

报错：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未指定数据类型的原因导致的。

原创文章，转载请注明： 转载自搞代码

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~