Foreign Keys - advantage ?
This is a discussion on Foreign Keys - advantage ? within the MySQL forums, part of the Database Server Software category; --> As a newbie to SQL I guess the only advantage I can see of setting up Foreign Keys is ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 10:12 AM
| |||
| |||
 Re: Foreign Keys - advantage ? NA news wrote: > As a newbie to SQL I guess the only advantage I can see of setting up > Foreign Keys is to help ensure you don't get left with 'orphan' rows, > right ? > TIA, > Nick A Things like "cascade on delete" save programming      |
|
02-28-2008, 10:12 AM
| ||||
| ||||
| Re: Foreign Keys - advantage ? On 20.02.2007 22:09, Paul Lautman wrote: > NA news wrote: >> As a newbie to SQL I guess the only advantage I can see of setting up >> Foreign Keys is to help ensure you don't get left with 'orphan' rows, >> right ? >> TIA, >> Nick A > > Things like "cascade on delete" save programming .... and make the DB maintain consistency automatically. robert |
 |
« New 'MySQL Cluster Carrier Grade Edition' Reduces Cost & Complexity of Telecom Subscriber Databases (Business Wire via Yahoo! Finance)
|
support for multiple languages »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 05:01 PM.
