mysql test db 생성용 프로시저 loop insert 문

생성하기

DELIMITER $$

DROP PROCEDURE IF EXISTS input$$

CREATE PROCEDURE input()

BEGIN

 DECLARE val INT DEFAULT 0;

 

 WHILE val < 9999 DO

  INSERT INTO `dprc_rto`(BIZTYPE_CAT, BIZTYPE_DIV, BIZTYPE_SEC, PASS_YY_DPRC_RTO, RGT_DTM) VALUES (val, val, val, 1, NOW());

  SET val = val + 1;

 END WHILE;

END $$

DELIMITER $$

CALL input;        //프로시저 호출 CREATE PROCEDURE input()

---

수정하기

USE `vas`;

DROP procedure IF EXISTS `input`;

DELIMITER $$

USE `vas`$$

CREATE DEFINER=`vas`@`%` PROCEDURE `input`()

BEGIN

 DECLARE val INT DEFAULT 0;

 

 WHILE val < 9999 DO

  INSERT INTO `dprc_rto`(BIZTYPE_CAT, BIZTYPE_DIV, BIZTYPE_SEC, PASS_YY_DPRC_RTO, RGT_DTM) VALUES (val, val, val, 1, NOW());

  SET val = val + 1;

 END WHILE;

END$$

DELIMITER ;