On Sep 15, 2008, at 10:59 AM, Micah Gersten wrote:
Use 2 tables. You never know what the app might grow into and you
should do it right the first time.
That's what I was thinking too... Just wanted to hear it from someone else... NOW I get to learn about foreign keys and how to update things with them!
So if anyone knows of a good resource I'd appreciate it... Until then, I'm off to search the web and figure this stuff out!
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
11287 James St
Holland, MI 49424
www.raoset.com
japruim@raoset.com
This for mysql only but it can give some info you may find useful.
This is a very enlightening article for starters in order to see the sql part.
http://articles.techrepublic.com.com/5100-10878_11-6035435.html
The mysql manual could also give you an idea on that.
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html
--
Thodoris