DROP PROCEDURE
IF EXISTS test_insert;
DELIMITER ;;
CREATE PROCEDURE test_insert ()
BEGIN
    DECLARE
        i INT DEFAULT 1 ;
    WHILE i < 1000 DO
        INSERT INTO student (NAME, age)
    VALUES
        (“ssss”, 30) ;
    SET i = i + 1 ;
    END
    WHILE ;
    END;;
CALL test_insert () ;

declare
  idxnumber(22) :=1;
begin
 loop
    idx := idx +1;
   insertintosfss_yb_sign
      (ID, AGENT_CODE, SIGN_TIME, SIGN_ADDR, LONGITUDE, LATITUDE)
   values
      (‘ull’|| to_char(idx),
      ‘3000000002’,
       to_date(’18-12-2015 16:32:19′,’dd-mm-yyyy hh24:mi:ss’),
      ‘null’,
      ‘117.194771’,
      ‘39.142272’);
   exitwhenidx >3000;
 endloop;
end;