게시판 더미 데이터 생성

• MariaDB, MySQL

• DELIMITER $$
  DROP PROCEDURE IF EXISTS loopinsert$$
  CREATE PROCEDURE loopinsert()
  BEGIN
  	DECLARE i INT DEFAULT 1;
      
      WHILE i <= 500 DO
  		INSERT INTO board (
  			board_title
  		) values (
  			concat('제목', i)
  		);
          
          SET i = i + 1;
  	END WHILE;
  END$$
  DELIMITER $$
  
  CALL loopinsert();

• Oracle

• BEGIN
  FOR i IN 1..500 LOOP
  INSERT INTO BOARD(title) 
  VALUES(CONCAT('제목', i);
  END LOOP;
  END;