text_inv ="" for i in text: text_inv = i + text_inv
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?
function Ejercicio5() {
for (let i = 1; i <= 450; i++) {
if (i % 5 == 0) {
}
document.querySelector("#pResultado5").innerHTML += i + " ";
}
}
I need to display numbers between 1 and 450 that are multiples of 5 on button press. I created my code, it works but it only shows me the numbers between 1 and 450 but not the multiples of 5. I need help, thanks!
Excuse me I have a dilemma I want to update data from the table "f_posts" of the columns "ID" and "post_title" to the table "f_quiz" in the columns "id_quiz" and "quiz" but do it automatically without repeating existing data in mysql . This is my query to insert the data, but I would like a trigger to update it without repeating the records.
INSERT INTO f_quiz (`Id_quiz`,`quiz`) SELECT `ID`,`post_title`FROM f_posts;
UPDATE EXAMPLE (SYNTAX IS WRONG)
DROP TRIGGER IF EXISTS `dato`;
DELIMITER $$
CREATE TRIGGER `dato`
AFTER INSERT ON `f_posts`
FOR EACH ROW
BEGIN
UPDATE INTO `f_quiz` (`Id_quiz`,`quiz`) SELECT (NEW.`ID`,NEW.`post_title`);
END$$
DELIMITER ;
Any idea how to do it, if not you can with a Tigger, how would you do it with a manual query???
When I register a request and add "teams" to said request, it generates a list of the teams I have from the said client that I previously selected...
How can I check if this list is empty or not?
string Equipos = string.Empty;
List<string> EquiposNombre = new List<string>();
bool isEmpty = isEmpty(EquiposNombre);
if (isEmpty)
{
foreach (var ar in solicitud.ActivosReportados)
{
EquiposNombre.Add(Utilidades.ActivoNombrePorActivoTipoIdActivoId(ar.ActivoId,
ar.ActivoTipoId));
}
Equipos = string.Join(", ", EquiposNombre);
}
I have a boolean variable to check if it is empty but it does not work for me