mysql¹ý³ÌÓαê

DELIMITER $$
DROP PROCEDURE IF EXISTS `heli`.`prodtest` $$
CREATE PROCEDURE `heli`.`prodtest` ()
BEGIN
  /*¾Ö²¿±äÁ¿µÄ¶¨Òå declare*/
  declare pid varchar(45) default '';
  declare pq int default 0;
  declare pk double default 0.0;
  declare cur1 CURSOR FOR SELECT product_id,product_quantity,product_kg from productstock;
  /* ÓαêÒì³£ºóÉèÖÃpidΪNULL */
  declare CONTINUE HANDLER FOR SQLSTATE '02000' SET pid = null;
  /*¿ªÓαê*/
     OPEN cur1;
        FETCH cur1 INTO pid,pq,pk;
        WHILE (pid is not null) DO
            /* dosomething */
            select pid,pq,pk;
            FETCH cur1 INTO pid,pq,pk;
        END WHILE;
     CLOSE cur1;
END $$
DELIMITER ;