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

Popular posts from this blog

python - Selenium remoteWebDriver (& SauceLabs) Firefox moseMoveTo action exception -

html - How to custom Bootstrap grid height? -

transpose - Maple isnt executing function but prints function term -