mysql 循环

create procedure pro5()
  begin
   declare i int default 10004;
    while i<20000 do
    set i=i+1;
    select CONCAT('370',i);
      INSERT INTO Alert
   (`ENTITY`, `DISCRIMINATOR`, `ID`, `GROUPNAME`, `CATEGORY`, `SEVERITY`, `PREVIOUSSEVERITY`, `CREATETIME`, `MODTIME`, `MMESSAGE`, `SOURCE`, `WHO`, `WEBNMS`)
VALUES
   (CONCAT('370',i), 'ExtendAlert',i , '', '', 4, -1, 1328064709171, 1328064709171, '', '373', '', '');

INSERT INTO ExtendAlert
   (`ENTITY`, `COUNT`, `ALARMID`, `RELATEID`, `SEQUENCE`, `ALARMNAME`, `ALARMTYPE`, `MONAME`, `MOIP`, `MOMAINTYPE`, `MOSUBTYPE`, `CLEARSTATUS`, `CLEARTIME`, `CLEARUSER`, `CONFIRMSTATUS`, `CONFIRMTIME`, `CONFIRMUSER`, `SYSEFFECT`, `ALARMDESC`, `ALARMPARAM`, `ADVICE`, `LOCATION`, `PRODUCTNAME`)
VALUES
   (CONCAT('370',i), 1, '0xB00712364', '', -1, '0xB00712364.alarm.name', 1, 'R1', '129.111.100.137', 'lego.dic.legosystem.maintype', 'lego.dic.legosystem.subtype', 0, 0, '', 0, 0, '', '0xB00712364.alarm.effect', '0x000803220005.alarm.desc', 'R1,129.111.100.137', '0x000803220005.alarm.advice', '0x000803220005.alarm.location', '');


INSERT INTO ANNOTATION
   ( `AAID`,`DISCRIMINATOR`, `ENTITY`, `MODTIME`, `NOTES`, `SEQUENCE`, `CLEARSTATUS`, `CLEARTIME`, `CLEARUSER`, `CONFIRMSTATUS`, `CONFIRMTIME`, `CONFIRMUSER`)
VALUES
   ( i,'AlertDetail', CONCAT('370',i), 1328061824000, '', 262458, 0, 0, '', 0, 0, '');
     
    end while;
    end;