List: | General Discussion | « Previous MessageNext Message » | |
From: | Ed Carp | Date: | March 13 1999 10:38am |
Subject: | Re: Some questions/concerns about MySQL | ||
View as plain text |
>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
Thread | ||
---|---|---|
• Some questions/concerns about MySQL | Eric Maryniak | 12 Mar |
• Re: Some questions/concerns about MySQL | Sasha Pachev | 12 Mar |
• Re: Some questions/concerns about MySQL | Christian Mack | 13 Mar |
• Re: Some questions/concerns about MySQL | Thimble Smith | 13 Mar |
• Re: Some questions/concerns about MySQL | Ed Carp | 13 Mar |
• Re: MySQL 3.23.39 released | Steven Roussey | 15 Jun |
• Re: MySQL 3.23.39 released | Michael Widenius | 15 Jun |
• RE: MySQL 3.23.39 released | Steven Roussey | 19 Jun |
• RE: MySQL 3.23.39 released | Michael Widenius | 19 Jun |
• mysqld 3.23.36 -- new connections get stuck in "Open Tables" | Jamie Mason | 18 Jun |