cursor_sample.sql

CREATE PROCEDURE testy ()
  BEGIN
    declare a, b int;

    DECLARE done int DEFAULT 0;

    DECLARE masterCursor CURSOR
        FOR
     SELECT SUM(sales.amount) amt, sales.item_month
       FROM sales
      WHERE RETAILER_ID = 336
      GROUP BY sales.item_month;

    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;

       OPEN masterCursor;
         REPEAT
         FETCH masterCursor INTO a, b;
            IF NOT done THEN
               insert into revplan (amount, item_month)
               values (a,b);
           END IF;

         UNTIL done END REPEAT;

       CLOSE masterCursor;

  END