Re: foreign key design stratgies

2005-04-11 Thread Rhino
- Original Message - From: Steve Lefevre [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, April 11, 2005 12:26 AM Subject: foreign key design stratgies Hey folks - I'm having a little problem understanding ON DELETE foreign key constraints. Here's my options from

foreign key design stratgies

2005-04-10 Thread Steve Lefevre
Hey folks - I'm having a little problem understanding ON DELETE foreign key constraints. Here's my options from the manual: [ON DELETE {RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT}] When do I use each one? I can find anything in the online manual that suggests how to construct a