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`; DEL..
Dev/Source Maker
2015. 8. 19. 13:27