Re: DELETE from more than one table
Hi Michael, Thankyou for your reply, unfortunately I am unable to use InnoDB tables... From: Michael Stassen [EMAIL PROTECTED] To: shaun thornburgh [EMAIL PROTECTED] CC: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: DELETE from more than one table Date: Tue, 08 Jun 2004 12:50:39 -0400 The manual says ON DELETE CASCADE with foreign keys is available for InnoDB tables starting with mysql 3.23.50 http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html. Michael shaun thornburgh wrote: Hi Robert, Thanks for the reply but unfortunately I am still using version 3.23.54 and I am unable to change it! From: Robert A. Rosenberg [EMAIL PROTECTED] At 14:01 + 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] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: DELETE from more than one table
Hi Robert, Thanks for the reply but unfortunately I am still using version 3.23.54 and I am unable to change it! From: Robert A. Rosenberg [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: DELETE from more than one table Date: Mon, 7 Jun 2004 18:04:38 -0400 At 14:01 + 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] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DELETE from more than one table
The manual says ON DELETE CASCADE with foreign keys is available for InnoDB tables starting with mysql 3.23.50 http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html. Michael shaun thornburgh wrote: Hi Robert, Thanks for the reply but unfortunately I am still using version 3.23.54 and I am unable to change it! From: Robert A. Rosenberg [EMAIL PROTECTED] At 14:01 + 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]
Re: DELETE from more than one table
On Mon, 07 Jun 2004 12:36:47 + shaun thornburgh [EMAIL PROTECTED] wrote: Hi, Is it possible to DELETE from more than one table in one command? Thanks for your help DROP TABLE IF EXISTS table1, table2, table3; http://dev.mysql.com/doc/mysql/en/DROP_TABLE.html Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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? From: Paul McNeil [EMAIL PROTECTED] To: shaun thornburgh [EMAIL PROTECTED] Subject: RE: DELETE from more than one table Date: Mon, 7 Jun 2004 08:47:04 -0400 I believe you can use... Delete from TableA join TableB ON TableA.data = TableB.data WHERE TableA.otherData = myNeeds. GOD BLESS AMERICA! To God Be The Glory! -Original Message- From: shaun thornburgh [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 8:37 AM To: [EMAIL PROTECTED] Subject: DELETE from more than one table Hi, Is it possible to DELETE from more than one table in one command? Thanks for your help _ Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: DELETE from more than one table
At 14:01 + 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]
DELETE from more than one table
Hi, Is it possible to DELETE from more than one table in one command? Thanks for your help _ Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]