mysql loop

mysql中循环,查找并插入数据

DELIMITER //
DROP PROCEDURE IF EXISTS doWhile;
CREATE PROCEDURE doWhile()
  BEGIN
    DECLARE hair_id VARCHAR(300);
		DECLARE sortx INT DEFAULT 0;
		DECLARE review_id INT;
    DECLARE cursor1 CURSOR FOR (SELECT system_hairstyle_id,sortx FROM hair_system WHERE status = 1);
		set review_id = 99;
    OPEN cursor1;
    read_loop: LOOP
      FETCH FROM cursor1 INTO hair_id,sortx;
      INSERT INTO hair_store (review_id,system_hairstyle_id,sort,status) VALUE (review_id, hair_id,sortx,1);
    END LOOP;
    CLOSE cursor1;
  END;
//
CALL doWhile();

这句语句是是定义了部分变量,并从cursor中读取信息,并将相应信息放入到新表中
来源