SA-MP Forums Archive
Big mysql query - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Big mysql query (/showthread.php?tid=277346)


Big mysql query - ajwar - 17.08.2011

HI, how to make a big mysql query?

now i have 3 768size queries which i think leads to db overloading.

If i try to make bigger one i get error: input line to long.

Any suggestions?

Re: Big mysql query - KingTurtle - 17.08.2011

Set
pawn Код:
new query[(size of yours)];
to

pawn Код:
new query[800];
If that doesn't work, then you should try

pawn Код:
format(query, sizeof query, [string here], [data here]);
format(query, sizeof query, [string here], [data here]);
format(query, sizeof query, [string here], [data here]);
format(query, sizeof query, [string here], [data here]);
format(query, sizeof query, [string here], [data here]);
format(query, sizeof query, [string here], [data here]);
mysql_query(%s);
Just alot of queries and then save it as one

(Sorry, I don't know how mysql_query syntax is)