mysqlimport

Download mysql eBook

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.

Related Examples

Stats

33 Contributors: 1
Friday, August 5, 2016
Licensed under: CC-BY-SA

Not affiliated with Stack Overflow
Rip Tutorial: info@zzzprojects.com

Download eBook