DROP PROCEDURE if exists test.filldata; delimiter // CREATE PROCEDURE test.filldata() BEGIN DECLARE num int; DECLARE t int; SET num = 0; SET t=1451577600; WHILE num < 1000 DO insert into test.telnet(start_time,start_time_nano,end_time,end_time_nano,client_addr,client_addr_value,client_port,server_addr,server_addr_value,server_port,server_user_name,server_password,request_command) VALUES (t+num,0,t+num,0,'192.168.3.70', 3232236358, 45035, '192.168.3.206', 3232236494, 23, 'administrator', 'trustmo', 'asdkgag'); SET num = num+1; END WHILE; END / delimiter ; show create procedure test.filldata;