MySQL: Update all values in table from another table
#6

Quote:
Originally Posted by kurta999
View Post
BlueG's R7 plugin, but after some calculations run this query in cicle in samp server is impossible, because i have ~90k players..
LOL
Quote:

I want to update the "maths" in `players` table for number of rows for the player reg id from math table, but this will count all reg id in maths table and will update the players table for same value.

Did i understand that:

1. you want to get the count of all rows in table "math"
2 then you wan to insert received number into "maths" from the table players
?
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)