Re: Some questions/concerns about MySQL

[Ed Carp]

>The only thing triggers can do for you is an 'on delete cascade' that's
all.


You know, thinking about it, in a lot of applications, you *don't want* to
cascade deletes - updates, maybe, but not deletes.  Deletes should always be
a conscious decision, not a side effect of an automatic process.

I know that will get me in trouble with some purists, but I think it's far
safer to have to do something like "update table set linked_id=new_value
where linked_id=old_value" than it would be to accidentally delete customer
records or such.
--
Ed Carp, N7EKG - erc@stripped - 9403672744@stripped for URGENT
messages only!
Web: http://www.pobox.com/~erc