This stored procedure is creating incremental dummy data in sample article table.

procedure.sql

delimiter //
create procedure insert_loop(in x int)
    begin
      declare max_id int;
      declare i int;
      set i = 0;
      select max(id) into max_id from article;
      while i < x do
       set i = i + 1;
       insert into article values (max_id + i, concat('article', i), concat('body_', i));
      end while;
    end
//
delimiter ;