mysqlimport

Parameters

Parameter | Description | —— | —— |--delete -D | empty the table before importing the text file |--fields-optionally-enclosed-by | define the character that quotes the fields |--fields-terminated-by | field terminator |--ignore -i | ignore the ingested row in case of duplicate-keys |--lines-terminated-by | define row terminator |--password -p | password |--port -P | port |--replace -r | overwrite the old entry row in case of duplicate-keys |--user -u | username |--where -w | specify a condition|

Remarks

mysqlimport will use the name of the imported file, after stripping the extension, to determine the destination table.