MySQL 10w-level MySQL data insertion _mysql

At first it didn't occur to me that this 10w of data a number inserts a number for half an hour only 2w. Later, an improved SQL BULK INSERT

Copy Code code as follows:

--Before optimizing the code
Insert into table (MOBILE) values (138000000);
Insert into table (MOBILE) values (138000000);
Insert into table (MOBILE) values (138000000);
......

--After the optimization
Insert into table (MOBILE) values (138000000), (138000000), (138000000);

--After optimization insert 12w data including PHP to do data processing, the cost is only about 6s.