mysql - Its possible to generate a SQL Database from a JSON file? -


well have database in json format, generated exel file, want modernize database , export mysql database. json structure:

[          {             "nombre": "test",             "especialidad": "test",             "especialidad2": "test pediatrica",             "especialidad3": "",             "cel": "2222009374947478474777",            etc.....         }, {             "nombre": "test",             etc.....         } ] 

if not possible or difficult, better option directly export exel file mysql?

thanks.

with mysql: have convert csv, use excel write sql, or write import procedure. mariadb skip entirely , use json column format: https://mariadb.com/kb/en/mariadb/column_json/

upgrading mysql mariadb easy , quick. gets little bit of performance increase + nice json column format (and few more).


Comments

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

php - .htaccess mod_rewrite for dynamic url which has domain names -

Website Login Issue developed in magento -