Convert JSON database to Mysql

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

+4
source share
3 answers

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.

enter image description here

+6
source

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

+1
source

Source: https://habr.com/ru/post/1667961/


All Articles