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