The least amount of code possible for this MySQL query?
Posted
by
ddan
on Stack Overflow
See other posts from Stack Overflow
or by ddan
Published on 2012-03-24T03:06:13Z
Indexed on
2012/03/24
5:29 UTC
Read the original article
Hit count: 139
I have a MySQL query that:
- gets data from three tables linked by unique id's.
- counts the number of games played in each category, from each user
- and counts the number of games each user has played that fall under the "fps" category
It seems to me that this code could be a lot smaller. How would I go about making this query smaller. http://sqlfiddle.com/#!2/6d211/1
Any help is appreciated even if you just give me links to check out.
© Stack Overflow or respective owner