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
February 18, 2018 01:22AM
Re: Import CSV file with JSON object
February 27, 2018 01:37AM

Sorry, you can't reply to this topic. It has been closed.

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.