[SQL] SQL 반복문

• SQL Gate
  

• Code

DELIMITER $$
CREATE PROCEDURE whileProc()
BEGIN
	DECLARE i INT;
	SET i = 1;
	
	WHILE (i <= 30) DO
		insert into t_mber_m (
				mber_sn, e_emp_id, mber_nm, sexdstn, telno, brthdy, regist_id, regist_dt,
				updt_id, updt_dt
				)
				values (
			   	NEXTVAL(mber_seq),
				'디자이너',
				CONCAT('더미', i ),
				'Male',
				'010-0000-0000',
				'960205',
				'디자이너',
				CURDATE(),
				'디자이너',
				CURDATE()
				);
		SET i = i + 1;
	END WHILE;
	
END $$
DELIMITER;


CALL whileProc();