Load data infile: import millions of data entries in an excel file to the database within one minute.

Load data infile: import millions of pieces of data in the excel file into the database in MYSQL within one minute, and use the load data infile command. Step 1: Save the excel file as a csv text. csv files are separated by commas (,). 2. Enter an SQL statement in mysql.

Load data local infile "F:/top20/top2020.csv" into table top20 fields terminated by ',' (dir_1, dir_2, dir_3, keyword, buy, click, ppc );

 

Then execute the SQL statement ~ Note that fields must be placed behind fields terminated by ','; otherwise, an error is returned. The fields terminated by ',' indicates that data of each field is separated by commas in the text. If the Separator in the text is \ t, you do not need to write this field to separate the SQL statement and directly write the entered field. The rest is simple. You can understand it at a glance ~