The LOAD DATA INFILE query is used to import data from a text file either on the
MySQL server, or on the LOCAL (client) system (for example, a text file created with
a SELECT INTO OUTFILE query). The syntax of this command is given above; however
I refer you to the MySQL Reference Manual8 for a complete explanation of this
query and the issues that surround its use.