MySQL存储过程

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;