Customer MySQL Cursor

gistfile1.sql

DROP PROCEDURE IF EXISTS curupdate;

delimiter //

CREATE PROCEDURE curupdate()
BEGIN
  DECLARE done INT DEFAULT 0;
  DECLARE a INT;
  DECLARE b CHAR(16);
  DECLARE cur1 CURSOR FOR SELECT id,vantive_id FROM customer;
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
  OPEN cur1;

  REPEAT
    FETCH cur1 INTO a, b;
    IF NOT done AND b IS NOT NULL THEN
        INSERT INTO vantive_customer (customer_id, vantive_id) VALUES (a,b);
    END IF;
  UNTIL done END REPEAT;

  CLOSE cur1;
END

//
DELIMITER ;

call curupdate();
DROP PROCEDURE IF EXISTS curupdate;