mysqlループ挿入

--     
INSERT INTO energy.water_meter_data
VALUES(NULL,'60',234,12,2,12,
'12  ','12  ',str_to_date('2016-01-02','%Y-%m-%d %H:%i:%s'),
'501','','','',
'','','','',str_to_date('2016-01-02','%Y-%m-%d %H:%i:%s'),
'  ',str_to_date('2016-01-02','%Y-%m-%d %H:%i:%s'),'  ')

--     
CREATE DEFINER=`root`@`%` PROCEDURE `per2`()
begin
declare num int; 
set num=1; 
while num < 1000 do 
insert into energy.water_meter_data
VALUES(NULL,'60',234,12,2,12,
'12  ','12  ',str_to_date('2016-01-02','%Y-%m-%d %H:%i:%s'),
'501','','','',
'','','','',str_to_date('2016-01-02','%Y-%m-%d %H:%i:%s'),
'  ',str_to_date('2016-01-02','%Y-%m-%d %H:%i:%s'),'  ');
set num=num+1;
end while;
end

ストアド・プロシージャの呼び出し
call per2()