mysqlimport

mysqlimport –fields-terminated-by=, –lines-terminated-by=“” DBNAME FILENAME -u USERNAME -p –delete –columns=code,city,state,county

the LINES TERMINATED BY is defaulted to ''