Batch generation of test data using MySQL

MySQL can generate massive amounts of data through stored procedures:

The code is as follows:

--Create test table.

DROP TABLE t1;

CREATE TABLE t1(.

ID INT unsigned NOT NULL AUTO_INCREMENT.

Name VARCHAR (20) NOT NULL.

Status TINYINT unsigned NOT NULL DEFAULT 1.

PRIMAY KEY (id).

);

--Add data.

DROP Procedure insert_T1;

DELIMITER//.

CREATE PROCESS insert_T1().

BEGIN.

DECLARE num INT;

SET num; 1;

SET autocommit= 0.

WHILE num< 10000000 DO.

IF (num {46ef1d7cfbdffc0db57029f974d30095d18ea60dba1d7b2ffaf442b213727085}10000 = 0) THE.

COMMIT;

END IF;

Insert INTO t1 Values (NULL,' XXXXXXXX', 1);

SET num; Num; 1;

END WHILE;

COMMIT;

SET autocommit= 1;

END//.

DELIMITER;

Call insert_T1();