The LOAD DATA statement could be 15 even 20 faster than an ordinary INSERT so you should consider to use it when intending to insert a lot of data

The basic syntax of the LOAD DATA statement is shown below:

LOAD DATA INFILE file_name INTO TABLE table_name