Michael Durrant

263 reputation

bio	website	michaeldurrant.com
	location	Cambridge, MA
	age	47
visits	member for	1 year, 2 months
	seen	May 25 at 23:23
stats	profile views	14

rails ruby

	263 reputation	bio	website	michaeldurrant.com	visits	member for	1 year, 2 months
18 badges		location	Cambridge, MA		seen	May 25 at 23:23

summary answers questions tags badges favorites bounties reputation activity

30 Actions

suggestions reviews revisions comments badges posts accepts all

5h	awarded	Popular Question
May 24	comment	MySQL CSV LOAD DATA INFILE … doesn't want to load more than 72 lines Does a different set of data, say the last 100 rows instead of the first 73+, show exactly the same issues?
Apr 20	awarded	Yearling
Apr 16	awarded	Nice Answer
Jan 7	comment	Why should I create an ID column when I can use others as key fields? Yes. Updated the answer.
Jan 7	revised	Why should I create an ID column when I can use others as key fields? added 81 characters in body
Oct 21	answered	Users database to store access levels, can I move the non-essential information to another table?
Jun 27	accepted	*mysql workbench reverse engineer* is not connecting tables graphically. How to fix?**
Jun 27	awarded	Scholar
Jun 27	accepted	SQL Server dates - can I get date and hour?
Jun 27	asked	SQL Server dates - can I get date and hour?
Jun 23	awarded	Student
Jun 22	revised	*mysql workbench reverse engineer* is not connecting tables graphically. How to fix?** added 106 characters in body
Jun 22	comment	*mysql workbench reverse engineer* is not connecting tables graphically. How to fix?** The database I am looking at ALWAYS has othertablename_id as it is rails, so no guessing required and when I add the lines in manually I do the exact same thing every time, at least for the basic 1 to many's (which is the majority). self-referential's might be tricky.
Jun 22	comment	*mysql workbench reverse engineer* is not connecting tables graphically. How to fix? Sure, it seems like a few dialog boxes or settings could address the most common** scenarios of othertableID othertable_ID, etc. and no compound keys used for joins. The possibilities are endless sure, but the most common ones are out there.
Jun 22	asked	*mysql workbench reverse engineer* is not connecting tables graphically. How to fix?**
Apr 21	comment	Design question about student assessment data This may help: dba.stackexchange.com/questions/16002/…
Apr 21	revised	Data type for currency 'type' column, e.g. usd, cat, etc. Title made it look like currency column but detail showed it to be about currency TYPE.
Apr 21	suggested	suggested edit on Data type for currency 'type' column, e.g. usd, cat, etc.
Apr 21	comment	Survey database design: first version. Are there errors? This answer may help - dba.stackexchange.com/questions/16002/… - covers similar material.