You will need to create another table. In it you will need a columns
identifying what week it is, what team you are documenting, and the
statistics you want to store.
For individual player statistics, you will need yet another table. This
one would have columns identifying the player, what game
Hi
I have a hockey pool database and I want to be able to add each weeks
totals (goals, assists, etc.) for the players on each team.
Example:
Team 1 may have Hossa, Redden, and Forsberg. If each of them scored 2 goals
and 2 assists for week one, I want to be able to get the total of 12. Team
tw
On Thursday, November 28, 2002, at 08:06 AM, BobJ wrote:
You appear to be violating the "repeating value" rules of relational
database. Multivalue databases (Pick and Pick like) support this
concept
but they are rather uncommon now. You probably need to create a
related
table. Actually, you
28, 2002 7:48 AM
Subject: adding values together
>
>
> >
> > Hi, doeas anyone know if it's possible to add 2 or more numeric values
> >together that are in the same cell in Mysql:
> >IE: i have a cloumn called price that for any entry may contain more
> >than o
On Thu, Nov 28, 2002 at 12:48:29PM +, Steve Mansfield wrote:
> > Hi, doeas anyone know if it's possible to add 2 or more numeric values
> >together that are in the same cell in Mysql:
> >IE: i have a cloumn called price that for any entry may contain more
> >than one value, lets say £1.00 and
Hi, doeas anyone know if it's possible to add 2 or more numeric values
together that are in the same cell in Mysql:
IE: i have a cloumn called price that for any entry may contain more
than one value, lets say £1.00 and £2.00
Is there a way that i can get these values added together ?
I know