LOAD DATA:
This function used reads data from a file and insert into a table. Execution of the LOAD DATA statement is delayed until no other clients are reading from the table.LOAD DATA LOCAL works
only if your server and your client both have been enabled to allow it. The difference between LOAD DATA and LOAD DATA LOCAL is, in LOAD DATA, file is opened by mysqld. But in LOAD DATA LOCAL, file is opened by client program - usually using libmysqlclient library.
Syntax :
LOAD DATA [LOCAL] INFILE [file_name] INTO TABLE [table_name]
Example :
LOAD DATA INFILE ‘backup.txt’ INTO TABLE wordlist;
