MySQL Forums
Forum List  »  MySQL Workbench

Re: Import CSV file with JSON object
Posted by: Marcin Szalowicz
Date: February 27, 2018 01:37AM

Sravani,
please try to use Table Import Wizard with something like this:
"pzzaID";"type"
1;{"cheese": 0, "pepperoni": 0, "hawaiian": 1}
2;{"cheese": 0, "pepperoni": 1, "hawaiian": 0}
3;{"cheese": 1, "pepperoni": 0, "hawaiian": 0}

In general, the wizard is trying to autodetect but as you can see it's not 100% accurate.

Marcin SzaƂowicz, MySQL Developer Tools
Oracle Corporation

Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/5.6/en/index.html

Options: ReplyQuote


Subject
Views
Written By
Posted
249
February 18, 2018 01:22AM
Re: Import CSV file with JSON object
77
February 27, 2018 01:37AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.