لطفا منتظر باشید ...
LOAD DATA INFILE
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE
'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name
[FIELDS
[TERMINATED BY 'string']
[[OPTIONALLY] ENCLOSED BY 'char']
[ESCAPED BY 'char'] ]
[LINES TERMINATED BY 'string']
[IGNORE number LINES]
[(col_name, ...)]
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, the reader is referred
to the MySQL Reference
Manual for a complete explanation of this query and the issues that
surround it.
