Re: Import CSV file with JSON object

[Marcin Szalowicz]

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