MySQL: Update all values in table from another table

Linear Mode

kurta999
High-roller

Posts: 913
Threads: 70
Joined: Apr 2009
Reputation: 0

23.08.2012, 20:31

Quote:

Originally Posted by AndreT

UPDATE players SET maths=(SELECT COUNT(winner_id) FROM maths WHERE maths.winner_id=players.id)
What about this one?

I'm idiot.. LoL
Thanks!

Very nice, this works!

I now searched for while loop in mysql, and other shits, but this solved my problem.
(I was gave rep for you before few monts, so i don't know now give for this

)

Find

« Next Oldest | Next Newest »

Messages In This Thread

MySQL: Update all values in table from another table - by kurta999 - 23.08.2012, 18:11

AW: MySQL: Update all values in table from another table - by Mellnik - 23.08.2012, 18:34

Re: MySQL: Update all values in table from another table - by kurta999 - 23.08.2012, 18:47

AW: MySQL: Update all values in table from another table - by Mellnik - 23.08.2012, 18:52

Re: AW: MySQL: Update all values in table from another table - by kurta999 - 23.08.2012, 19:04

AW: Re: AW: MySQL: Update all values in table from another table - by Mellnik - 23.08.2012, 19:29

Re: MySQL: Update all values in table from another table - by AndreT - 23.08.2012, 19:47

Re: MySQL: Update all values in table from another table - by kurta999 - 23.08.2012, 20:31

Re: MySQL: Update all values in table from another table - by TwisT3R - 23.08.2012, 20:55

View a Printable Version

Forum Jump:

Users browsing this thread: 2 Guest(s)

Login
Username:
Password:	Lost Password?
	Remember me