MySQL Forums
Forum List  »  Newbie

One table including entries from several users
Posted by: Dermy sqlheld
Date: June 09, 2005 03:31PM

Hi all,

I have a table, which looks like this:

user_id | date | score | stuff1 | stuff2

Every entry of every user is pushed into this table.

Now i want to select all entries from only one certain user, say user_id = 3, and build the sum of his scores. How can i filter the entries of one user_id?

Does a command like "select * from user_table where user_id=3" suffice? But how do i get the several entries?

You understand my question? Sorry for the poor english...

Regards. Dermy.

Options: ReplyQuote


Subject
Written By
Posted
One table including entries from several users
June 09, 2005 03:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.