//存储过程
DELIMITER $$
DROP PROCEDURE IF EXISTS `fans`.`votecursor`$$
CREATE DEFINER=`fans`@`%` PROCEDURE `votecursor`(out _id varchar(100))
BEGIN
declare id_0 varchar(100) default '';
declare cr0 cursor for select voteuser.id from voteuser;
open cr0;
fetch cr0 into id_0;
close cr0;
set _id = id_0;
END$$
DELIMITER ;
SQLyog调用:
call votecursor(@a);
select @a ;