Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Load a file that has data values separated by commas, and lines ending with carriage returns

shell> mysqlimport --fields-terminated-by=,--lines-terminated-by="\r" world City.txt