Mysql Stored Procedureがパフォテとかやるとき便利だった

DELIMITER $$
CREATE PROCEDURE prepare_sample_log( IN record_num INT )
BEGIN
  DECLARE i INT DEFAULT 1;
  WHILE i < record_num DO
    INSERT INTO sample_log (
      id, created_at
    ) VALUES (
      i, UNIX_TIMESTAMP()
    );
    SET i = i + 1;
  END WHILE;
END$$
DELIMITER ;

truncate table sample_log;
call prepare_sample_log(300000);