Mysql 存储过程批量添加数据

create procedure add_data_test()
  begin
   declare a int default 1;
   while (a <= 1000) do
         INSERT INTO t_customer(first_name,last_name) VALUES('李',CONCAT('天',a));
   set a = a + 1;
   end while;
  end
 call add_data_test()