1.創(chuàng)建存儲過程:
delimiter $$
create procedure pro()
begin
set @i=1;
set @max=10000000;
while @i<@max do
INSERT INTO `merchant_list` (`id`,`batch_id`,`merchant_name`,`merchant_kid`,`merchant_showid`,`merchant_area`,`area_size`,`merchant_phone`)
VALUES (@i,5,'redapple','K001002','G-001-02','G',50,'13800000000');
set @i = @i + 1;
end while;
end $$
delimiter ;
2.調(diào)用存儲過程
call pro();
存儲過程的編寫