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();
