[MySQL] loop 프로시저

delimiter $$
create procedure metaDataInsert()
begin
  SET @i = 0;
  while @i < 100 DO
    insert into METATBL (META) VALUE (@i);   
    set @i = @i + 1;
  end while;
END; $$

//drop
drop procedure if exists metaDataInsert;

//call
call metaDataInsert();