利用mysql游标循环结果集

很多时候自己添加测试数据会用到mysql编程，其中存储过程就非常的重要，所以在这里写一个返回用户ID号用逗号拼接的例子

现在发现mysql完全可以编程，一门彻底的编程语言，数据类型还是强类型的，我喜欢

<span style="font-size:24px;"><strong>USE test;
DELIMITER //
CREATE PROCEDURE pro8(OUT para1 VARCHAR(20))
BEGIN
	DECLARE myid INT(11);
	DECLARE title VARCHAR(100);
	DECLARE i INT DEFAULT 0;
	DECLARE str VARCHAR(60);
	DECLARE len INT(2);
	DECLARE num INT;
	DECLARE cur CURSOR FOR SELECT id FROM test.`info`;
	SELECT COUNT(*) INTO num FROM test.`info`;
	SET str='';
	OPEN cur;
	WHILE i<num DO
	FETCH cur INTO myid;
	SET str = CONCAT(str,myid,',');
	SET i=i+1;
	END WHILE;
	SELECT LENGTH(str) INTO len;
	SELECT SUBSTR(str,1,len-1) INTO para1;
	CLOSE cur;
	
	
END//
DELIMITER ;
CALL pro8(@a);
SELECT @a;

</strong></span>