[darkHero]

Imagine that I have a large amount of data to save, it would be better to execute everything in a single query or in several with a smaller string.

A query

Quote:

new query[2500]; // Example, in case of having a lot of data format(query, sizeof(query), "UPDATE `USER` SET `var`=%d, `var2`=%d, `var3`=%d, `var4`=%d WHERE `ID`='%d'", var, var2, var3, var4, id); mysql_tquery(conexion, query, "", "");

Various queries

Quote:

new query[256]; // Example format(query, sizeof(query), "UPDATE `USER` SET `var3`=%d, `var4`=%d WHERE `ID`='%d'", var3, var4, id); mysql_tquery(conexion, query, "", ""); format(query, sizeof(query), "UPDATE `USER` SET `var`=%d, `var2`=%d WHERE `ID`='%d'", var, var2, id); mysql_tquery(conexion, query, "", "");

These are examples.