Importing data into MySQL

The LOAD DATA statement reads rows from a file into a table at a very high speed. The file name must be given as a literal string.

LOAD DATA [LOW_PRIORITY CONCURRENT] [LOCAL] INFILE 'file_name'
[REPLACE IGNORE]
INTO TABLE tbl_name
[CHARACTER SET charset_name]
[{FIELDS COLUMNS}
[TERMINATED BY 'string']
[
[OPTIONALLY] ENCLOSED BY 'char']
[ESCAPED BY 'char']
]
[
LINES
[STARTING BY 'string']
[TERMINATED BY 'string']
]
[IGNORE number LINES]
[(col_name_or_user_var,...)]
[SET col_name = expr,...]
more...

The mysqlimport client provides a command-line interface to the LOAD DATA INFILE SQL statement. Most options in mysqlimport correspond directly to clauses of LOAD DATA INFILE syntax.
shell> mysqlimport [options] db_name textfile1 [textfile2 ...]
more...

- Palani E