Mysql inserts tens of millions of test data records quickly

Mysql inserts tens of millions of test data records quickly

Add data through stored procedures:

Drop procedure if exists t1; create procedure t1 () begin DECLARE I int default 0; DECLARE j int default 0; WHILE (I <= 15000000) do insert into 'test' ('code', 'name') VALUES ('sdfasdfas ', 'aaa'); SET I = I + 1; if mod (I, 1000) = 0 then commit; end if; end while; end;/* call the Stored Procedure */call t1 ();

Important: Change the mysql storage mode before executing the insert operation !! Otherwise, the insertion speed is slow !!

Alter table test ENGINE = MYISAM;

The default value is InnoDB. If you still need this value, you can change it back after the insertion is complete.