MySQL Forums
Forum List  »  Newbie

Re: count of a certain value in two columns
Posted by: Khaba
Date: July 16, 2005 09:39AM

CREATE TABLE `scorelist` (
`T_id` int(11) NOT NULL auto_increment,
`player` int(11) NOT NULL default '0',
`a1` int(11) default NULL,
`a2` int(11) default NULL,
PRIMARY KEY (`T_id`)
);

In this table i will manage a player statistics. The field player manages the id of every player in my database. Every time a player scores 1 point there are two players called assistman. Now at the end of a season (or during) I want to find out how many assists a player got from every other player. So one player can be the scorer, the assistman 1 or the assistman 2. It can be happens that a player can be assistman1 or assistman2 for a score.

Options: ReplyQuote


Subject
Written By
Posted
Re: count of a certain value in two columns
July 16, 2005 09:39AM


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.