At 14:01 +0000 on 06/07/2004, shaun thornburgh wrote about Re: DELETE from more than one table:

Hi Paul,

Thanks for the reply.

I actually need to delete data from about 10 tables, is this possible?

If the field in the tables is defined as a Foreign Key (with ON DELETE CASCADE), deleting the root key will do this (you can then insert it if you did not want to delete it but only the records that pointed at it). I do not know how helpful this is.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to