how to handle csv with commas in string fields using mysqlimport

Question

I have the following import:

mysqlimport --columns=column1,column2,etc --ignore-lines=1 --fields-terminated-by=, --verbose --local -u myuser -p mytable myfile.csv

I have a csv with the following:

Beatguide,company,/organization/beatguide,beatguide.me,http://beatguide.me,DEU,,Berlin,Berlin,,"",operating,"Beatguide, an electronic music events listing and discovery platform adding sound to the experience of searching for shows and club nights.",electronics|events|music,consumer electronics|events|hardware|media and entertainment|music and audio,0,,2013-01-01,,,,11-50,,,http://www.facebook.com/beatguide.me,,

You can see the short description has a comma, but is enclosed in quotes:

"Beatguide,

an electronic music events listing and discovery platform adding sound to the experience of searching for shows and club nights."

Currently, the above mysqlimport statement splits this field. What parameter do I add to the mysqlimport statement to have it respect the quotes and insert the string with the comma instead of splitting it?

Atma · Accepted Answer · 2017-07-26 07:52:17Z

3

I added the following option:

--fields-optionally-enclosed-by='"'

This solved my problem.

answered Jul 26, 2017 at 7:52

Atma

29.9k57 gold badges206 silver badges307 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to handle csv with commas in string fields using mysqlimport

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related