SQL BULK INSERT

BULK INSERT:

The first type:

INSERT into MyTable (id,name) VALUES (1, ' 123 ');
INSERT into MyTable (id,name) VALUES (2, ' 456 ');
INSERT into MyTable (id,name) VALUES (3, ' 789 ');

The second method uses union ALL to insert the operation:
INSERT into MyTable (id,name)
SELECT 4, ' 000 '
UNION All
SELECT 5, ' 001 '
UNION All
SELECT 6, ' 002 ';

PS: Online said the second kind of faster, but I measured after the execution of SQL statements in the thinkphp3.2, the case of continuous insertion of 1000, the first kind of faster (executing multiple INSERT statements simultaneously)

Let's do it, check it out.

SQL BULK INSERT