mysql 프로시져 루프돌며 insert

DELIMITER $$

DROP PROCEDURE IF EXISTS input$$
CREATE PROCEDURE input()
BEGIN

 DECLARE val INT DEFAULT 0;
 
 WHILE val < 500 DO
  INSERT INTO `테이블`(usr_id, kwd, mgr_id, reg_ymd) VALUES (val, val, val, NOW());
  SET val = val + 1;
 END WHILE;
END $$

DELIMITER;

CALL input;

DELETE FROM `테이블`;