MySQL Load Data infile

LOAD DATA [Low_priority | CONCURRENT] [LOCAL] INFILE ' file_name.txt '    |  IGNORE] into    TABLE tbl_name    [        Fields ' string ']        ' char ']        ' char ' ]    ]    [LINES        ' String ']        ' string '    ]  [number LINES]    [(col_name_or_user _var,... )]    = expr,...)]

The LOAD DATA INFILE statement is used to read rows from a text file at high speed and load a table. The file name must be a literal string.

' Data.txt', '' ' \ n 'persondata.txt ' into TABLE persondata (col1,col2);

MySQL Load Data infile