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;--如果存在此存儲(chǔ)過程則刪掉?
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,'測(cè)試數(shù)據(jù)');
? ? ? ? SET i = i+1;?
? ? END WHILE;?
END $?
CALL proc_initData5();
