mysql快速插入多数据

CREATE TABLE mfc_test_index

(empno  bigint(20) NOT NULL AUTO_INCREMENT,

ename VARCHAR(50) , 

  create_time datetime DEFAULT NULL,

  last_modify_time timestamp ,

  iid bigint(20) ,

  category varchar(20) ,

  PRIMARY KEY (empno),

    KEY `ename1` (`ename`)

) ;

DROP PROCEDURE IF EXISTS proc_initData5;--如果存在此存储过程则删掉 

DELIMITER $ 

CREATE PROCEDURE proc_initData5() 

BEGIN 

    DECLARE i INT DEFAULT 1; 

    WHILE i<=5000000 DO 

        INSERT

    INTO mfc_test_hus(ename,create_time,last_modify_time,iid,category) VALUES(i,'2018-01-01 00:00:00','',1,'测试数据');

        SET i = i+1; 

    END WHILE; 

END $ 

CALL proc_initData5();