Grouping Values 1

[EvilAsh]

This might be a simple question to answer but here goes.

I have a table with two columns - player & score.

The player column can have the same player name cropping up on numerous occasions and the score is a numerical value.

What I want to do is write a query that groups the player names and gives each players accumulative scores. For example:

The table entries:
Player 1, 10
Player 2, 5
Player 1, 2

Would return:
Player 1, 12
Player 2, 5
etc

I vaguely remember doing something like this in Access years ago but would appreciate your advice as to whether it can be done in MYSQL.

Thanks.

 

[cLFlaVA]

you want the sum function.

  select player
       , sum(score)
    from table
group by player

*cLFlaVA
----------------------------
[tt]( <P> <B>)¹³ * (<P> <.</B>)[/tt]

[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[EvilAsh]

Thanks, that worked like a charm. Sometimes I just need to step back and remember the basics! Still its all a learning curve...