Hello, I have a problem today and it is that when I learned to make an api, I made the DB in a JSON file so as not to complicate my life. Now that I want to import the DB to MySQL it won't let me since the objects have sub-objects
here an example:
"GatoID2":{
"correo" : "[email protected]",
"nombre": "Gato Fachero",
"Nombre_usuario": "gatofacherito22",
"Seguridad": {
"Password" : "1234",
"ID": "92648",
"UUID" : "0c5648b2-d78b-4a86-a2eb-85038d7aa002"
},
"Extras": {
"Perfil_IMG": "images/92648.png",
"banner" : "images/92648Banner.png",
"Color" : "#1c5050"
},
"Phone_Numbers": {
"Default" : "111 - 1111 - 111",
"Secondary" : "555 - 6643 - 555"
}
}
I would like to know if there is any way to pass all that to a table in MySQL or do I have to make separate tables for the sub-objects?