Efficient MySQL batch insert BULK INSERT

MySQL’s batch insert BULK INSERT is about the same speed as load data and is 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 a comma and ends with a semicolon. It only takes less than 10 to insert 100,000 records. Seconds