Convert JSON database to Mysql

Question

I am trying to convert a JSON data file to a MySQL database with some kind of web interface or script that will change me. Somebody knows? or how can i make a change instead?

Thank you so much

Answer 1

SQLizer is an online tool that can convert JSON to SQL scripts.

It will generate a table definition and several INSERT statements and make some reasonable assumptions about the type of columns needed.

Answer 2

, Windows, JSON SQL

http://www.whiterocksoftware.com/2017/01/intosql-converter.html

Answer 3

If you are looking for a tool that can convert up to 50 MB JSON (in the archive) for free, then I would recommend the Flexter data liberator https://jsonconverter.sonra.io/ . It generates CSV output, which can then be loaded into MySQL. With the corporate version you can load directly into MySQL.

Disclaimer: I work for Sonra