MySQL Forums
Forum List  »  Newbie

Re: Add points in many fields and one row
Posted by: Rick James
Date: May 31, 2014 05:30PM

> M.Player9_id

Are there exactly 9 "players" in each row? Even if there are, that is not a good way to design a database. There should be 9 (or fewer) rows in a Players table, all JOINed to central table.

Or maybe that is what you did? But did the JOINing backwards.

Mitspieler M should NOT have the list of players; instead it should deduce them by JOINing to view_punkte_kombiniert.

Once you have redesigned the schema, a simple SUM(), possibly with a GROUP BY, will provide the answer.

Options: ReplyQuote


Subject
Written By
Posted
Re: Add points in many fields and one row
May 31, 2014 05:30PM


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.