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).