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

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

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 t

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

2006-08-07 Thread Tim Lucia
ts.mysql.com > 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 t

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 (wi

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 recor