MySQLmysqlimport


Parameters

ParameterDescription
--delete -Dempty the table before importing the text file
--fields-optionally-enclosed-bydefine the character that quotes the fields
--fields-terminated-byfield terminator
--ignore -iignore the ingested row in case of duplicate-keys
--lines-terminated-bydefine row terminator
--password -ppassword
--port -Pport
--replace -roverwrite the old entry row in case of duplicate-keys
--user -uusername
--where -wspecify a condition

Remarks

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