mdoyle

694 reputation

212

bio	website
	location
	age
visits	member for	1 year
	seen	yesterday
stats	profile views	29

	694 reputation	bio	website		visits	member for	1 year
212 badges		location			seen	yesterday

summary answers questions tags badges favorites bounties reputation activity

104 Actions

suggestions reviews revisions comments badges posts accepts all

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?
Dec 4	answered	How to design tables for players in a tournament?
Dec 4	comment	How to design tables for players in a tournament? I'm still not quite clear on some of this but I will take a stab at what I think should work. You can tell me if there is any functionality you need that my suggestion doesn't seem to address.
Dec 4	comment	trigger in MySQL to disallow multiple row deletions at a time on a table Well, thanks! To be fair, I don't think it was the OP that downvoted it; the downvotes showed up with the cautionary comments.
Dec 4	comment	trigger in MySQL to disallow multiple row deletions at a time on a table Hahaha, yep, that was the one! :)
Dec 4	comment	trigger in MySQL to disallow multiple row deletions at a time on a table I don't recall. I think it was elsewhere.
Dec 4	comment	trigger in MySQL to disallow multiple row deletions at a time on a table Yeh, I answered one like this once. I told the guy not to do it, showed him how, explained why not to do it, and gave some alternatives. I still lost about 10 reputation. I'm going to upvote this because you told him what he asked, AND told him not to do it.
Dec 4	comment	How to design tables for players in a tournament? I don't understand your system well enough to give a proper answer. The DDL code you have included is helpful, but not quite enough for me. Could you describe or further define the four entities your tables represent? It seems like PLAYER_RESULT might represent the players, but that's not clear; nor is the difference between GAME and RESULT.
Dec 4	comment	Getting a “type” column from each table in query When I tested it, without the parentheses the LIMIT was only applying to the entire set. I was only getting 3 rows returned--the books. I'm running an older version (5.0.96), perhaps that behavior has changed.
Dec 3	answered	Getting a “type” column from each table in query
Dec 3	revised	Identify why a user can drop a database changed "use" to "user" in last sentence.