mysql - how to handle csv with commas in string fields using mysqlimport -
i have following import:
mysqlimport --columns=column1,column2,etc --ignore-lines=1 --fields-terminated-by=, --verbose --local -u myuser -p mytable myfile.csv
i have csv following:
beatguide,company,/organization/beatguide,beatguide.me,http://beatguide.me,deu,,berlin,berlin,,"",operating,"beatguide, electronic music events listing , discovery platform adding sound experience of searching shows , club nights.",electronics|events|music,consumer electronics|events|hardware|media , entertainment|music , audio,0,,2013-01-01,,,,11-50,,,http://www.facebook.com/beatguide.me,,
you can see short description has comma, enclosed in quotes:
"beatguide, an electronic music events listing , discovery platform adding sound experience of searching shows , club nights."
currently, above mysqlimport statement splits field. what parameter add mysqlimport statement have respect quotes , insert string comma instead of splitting it?
i added following option:
--fields-optionally-enclosed-by='"' this solved problem.
Comments
Post a Comment