MySQL 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.
