mysql 循环输出结果_mysql游标循环的三种方式及打印结果查看

1、while方式：

DELIMITER

USE `ct1_test`

DROP PROCEDURE IF EXISTS `searchDate`

CREATE DEFINER=`greesj1b`@`%` PROCEDURE `searchDate`()

BEGIN

DECLARE tmpName VARCHAR(20) DEFAULT '' ;

DECLARE temp_id VARCHAR(1024) DEFAULT '' ;

DECLARE cur1 CURSOR FOR SELECT _id FROM `wp04_project` ORDER BY _id ASC LIMIT 5 ;

DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET tmpname = NULL;

OPEN cur1;

FETCH cur1 INTO tmpName;

WHILE ( tmpname IS NOT NULL) DO

/*自己的业务逻辑(我是把字符串相加)*/

SET tmpName = CONCAT(tmpName ," ") ;

SET temp_id = CONCAT(temp_id ,tmpName) ;

FETCH cur1 INTO tmpName;

END WHILE;

CLOSE cur1;

SELECT temp_id ;-- 打印结果

END

DELIMITER ;

2、Repeat方式：

DELIMITER