920 reputation
315
bio website
location
age
visits member for 1 year, 11 months
seen 2 hours ago

Feb
1
answered MySQL Tables crashing randomly
Feb
1
awarded  Informed
Jan
31
awarded  Enthusiast
Jan
28
answered Disabling “SHOW TABLES;” on mysql
Jan
25
comment sql error 1241 operand should contain 1 column
Extra +1 for the suggestion to normalize the table.
Jan
17
comment Split date range into indiviual records
And there's the join I couldn't conjure. Nice.
Jan
16
answered Split date range into indiviual records
Jan
3
comment MySQL SELECT query: i want show duplicated entries
There's only one row returned because there is only one row in the table categories where code_CAT has the value 14. Repeating that same id_code value in the IN doesn't change that. I don't follow why, if there is only one such row in the table, you want it repeated four times. Could you elaborate?
Dec
18
awarded  Citizen Patrol
Dec
14
awarded  Analytical
Dec
11
awarded  Custodian
Dec
11
reviewed Reviewed Lost databases in SQL Server 2012
Dec
11
comment Lost databases in SQL Server 2012
What kind of authentication are you using?
Dec
11
awarded  Quorum
Dec
11
comment How to design tables for players in a tournament?
I revised it--having to search two columns to find if a player was in a match was pretty knuckleheaded, not sure what I was thinking. Now you can get a player's games with a simple SELECT game_id FROM player_game WHERE player_id = x. Does that solve the problem?
Dec
11
revised How to design tables for players in a tournament?
added 46 characters in body
Dec
10
revised How to design tables for players in a tournament?
New design based on answers to questions, first explanatory paragraph updated accordingly.
Dec
7
comment How to design tables for players in a tournament?
So can a player be in more than one group at a time? For example, could there be one group that plays each other in billiards, and another that plays each other in darts, and someone could be in both groups?
Dec
7
comment How to design tables for players in a tournament?
I see, the groups aren't teams, they are collections of individuals that play against each other. Give me a bit to rework this.
Dec
6
comment How to design tables for players in a tournament?
Any feedback? Was it what you were looking for?