mysql利用存储过程造数据

drop procedure if exists t_add; -- 如果存在t_add 存储过程则删除
create procedure t_add(num int)

begin
declare i int;
set i=0;
while i<num do

INSERT INTO in_service_main (`mailboxid`,`callingtelno`,`calledtelno`,`calltime`,`endtime`,`timelens`,`mailmoney`,`callingtelno1`,`callingtelno2`,`callingtelno3`)
VALUES ('1', '15273276912', '13873276966', '2018-10-08 14:41:30','2018-10-08 14:45:30',i,i+0.01,'1','5','2');

set i=i+1;
end while;
end;

call t_add(100000); -- 调用存储过程，插入10万条数据