Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Using mysqlimport

% mysqlimport --local --lines-terminated-by="\r\n" --fields-terminated-by="," --fields-enclosed-by="\"" myDatabase mytbl.txt