RE: Delete one record, automatically delete other records...

Chris on Monday, August 07, 2006 6:19 PM said: > Foreign keys with an "on delete cascade" should do it. > > http://dev.mysql.com/doc/refman/5.1/en/example-foreign-keys.html Thanks everyone! -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

Re: Delete one record, automatically delete other records...

Chris W. Parker wrote: Hello, I'm not sure if this is possible (or what it's called, and how to search for it) at the db layer or if this has to be done at the application layer... I would like to be able to delete one record in one table and then automatically (without making an extra call to t

RE: Delete one record, automatically delete other records...

You want cascade deletion via foreign keys. http://dev.mysql.com/doc/refman/5.1/en/ansi-diff-foreign-keys.html is one such place to learn more. Tim > -Original Message- > From: Chris W. Parker [mailto:[EMAIL PROTECTED] > Sent: Monday, August 07, 2006 9:11 PM > To: mysql@lists.mysql.com

Re: Delete one record, automatically delete other records...

On 8/7/06, Chris W. Parker <[EMAIL PROTECTED]> wrote: Hello, I'm not sure if this is possible (or what it's called, and how to search for it) at the db layer or if this has to be done at the application layer... I would like to be able to delete one record in one table and then automatically (wi