DROP TABLE IF EXISTS TESTINDEX;

CREATE TABLE TESTINDEX(
ID INT,
NAME VARCHAR(10),
DESCRIPT VARCHAR(10)
);

SELECT * FROM TESTINDEX;

DROP PROCEDURE IF EXISTS insertIndex;

CREATE PROCEDURE insertIndex()
BEGIN
DECLARE i INT DEFAULT 0;
simpleLoop:LOOP
  INSERT INTO TESTINDEX VALUES(i,'TEST1','test2');
  SET i=i+1;
IF i=10000 THEN
LEAVE simpleLoop;
END IF;
END LOOP simpleLoop;
END

CALL insertIndex();