+- Burgershot (https://www.burgershot.gg)
+-- Forum: SA-MP (https://www.burgershot.gg/forumdisplay.php?fid=3)
+--- Forum: Support (https://www.burgershot.gg/forumdisplay.php?fid=12)
+--- Thread: [Server] MySQL Query ~ Which one is the most efficiency? (/showthread.php?tid=1549)
MySQL Query ~ Which one is the most efficiency? - LinesinRows - 2021-01-19
Code:
"UPDATE `players` SET q = %d, w= %d, e = %d, r = %d, t = %d, y = %d, u = %d, o = %d, a = %d, s = %d WHERE userid = %d", q, w, e...
mysql_tquery(blabla);
vs
"UPDATE `players` SET q = %d, w = %d, e = %d, r = %d, t = %d WHERE userid = %d", q, w, e...
mysql_tquery(blabla);
"UPDATE `players` SET y= %d, u = %d, o = %d, a = %d, s = %d WHERE userid = %d", y, u, o...
mysql_tquery(blabla);Which one and why?
Thanks for now.
RE: MySQL Query ~ Which one is the most efficiency? - Pinch - 2021-01-19
Neither;
Read about MULTI STATEMENTS