mysql 光标使用_在mysql存储过程中使用光标一个例子

drop procedure if exists countcomm;

delimiter $$

create procedure countcomm (IN param int(10),OUT result varchar(90))

begin

declare nums int(11);

declare count varchar(20);

declare i int(11) default 1;

declare cur_test CURSOR for select id from myfreax.blog_article order by id desc limit 3;

open cur_test;

while i <= param do

fetch cur_test into nums;

select count(*) INTO count from blog_comment where article_id = nums; #这里需要注意，自己总是把它写成select count from blog_comment where article_id = nums count(*) INTO; 结果被害惨自己

select concat_ws(',',result,count) into result;

set i=i+1;

end while;

close cur_test;

SELECT result,myfreax.blog_article.* from myfreax.blog_article order by id desc limit 3;

end;

$$

delimiter ;