Server MySQL Query ~ Which one is the most efficiency?

LinesinRows · 2021-01-19, 12:57 PM

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.

Pinch · 2021-01-19, 06:33 PM

Neither;

Read about MULTI STATEMENTS