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