[Server] MySQL Query ~ Which one is the most efficiency?

[LinesinRows]

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]

Neither;



Read about MULTI STATEMENTS