MySQL Forums
Forum List  »  MySQL Workbench

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

please try to use Table Import Wizard with something like this:
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
MySQL documentation can be found here:

Options: ReplyQuote

Written By
Re: Import CSV file with JSON object
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.