Efficient MySQL Batch insertion BULK insert

Original: http://www.open-open.com/code/view/1453702496573

MySQL Batch insertion BULK insert and load data are almost as fast and reliable.

The syntax is as follows

Suppose there is a table test (ID number,name VARCHAR (10))

INSERT into test values (1, ' AA '), (2, ' BB '),..... (100000, ' BB ');

That is, each record is separated by commas, ending with a semicolon, and inserting 100,000 records in less than 10 seconds

Efficient MySQL Batch insertion BULK insert