mysql 循环插入数据

1、创建存储过程，循环插入数据

delimiter $$
CREATE PROCEDURE myProc()
 DETERMINISTIC
 BEGIN
   DECLARE counter INT DEFAULT 576240;

   simple_loop: LOOP
     SET counter=counter+1;
     select counter;
     INSERT INTO `cdr_prod` (`id`,`calldate`,`clid`,`src`,`dst`,`dcontext`,`channel`,`dstchannel`,`lastapp`,`lastdata`,`duration`,`billsec`,`disposition`,`amaflags`,`accountcode`,`userfield`,`uniqueid`) 
     VALUES (counter,'2012-09-14 14:31:00','"8007" <8007>','8007','*','dynamic-nway-invite','SIP/8007-00000007','Local/8008@dynamic-nway-invite-dest-7e20;1','Dial','Local/8008@dynamic-nway-invite-dest,,g',35,21,'ANSWERED',3,'','','1347604260.21');
     IF counter=10 THEN
        LEAVE simple_loop;
     END IF;
   END LOOP simple_loop;
   SELECT 'I can count to 10';
 END$$
 
 call myProc();