Delete one record, automatically delete other records...

2006-08-07 Thread Chris W. Parker
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 the db) delete other

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

2006-08-07 Thread Daniel da Veiga
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

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

2006-08-07 Thread Tim Lucia
Subject: Delete one record, automatically delete other records... 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

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

2006-08-07 Thread Chris
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

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

2006-08-07 Thread Chris W. Parker
Chris mailto:[EMAIL PROTECTED] 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/mysql