procedure書くのも久しぶりだww
DELIMITER $$
DROP PROCEDURE IF EXISTS `testProcedure` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `testProcedure`()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE a INT;
DECLARE b varchar(45);
DECLARE cur1 CURSOR FOR select userid,username from olduser;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
OPEN cur1;
REPEAT
FETCH cur1 INTO a, b;
IF NOT done THEN
INSERT INTO newuser VALUES (a,b);
END IF;
UNTIL done END REPEAT;
CLOSE cur1;
END $$
DELIMITER ;