Re: DELETE from more than one table

2004-06-09 Thread shaun thornburgh
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

Re: DELETE from more than one table

2004-06-08 Thread Michael Stassen
ersion 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 p

RE: DELETE from more than one table

2004-06-08 Thread shaun thornburgh
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 +00

RE: DELETE from more than one table

2004-06-07 Thread Robert A. Rosenberg
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

RE: DELETE from more than one table

2004-06-07 Thread shaun thornburgh
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:4

Re: DELETE from more than one table

2004-06-07 Thread Josh Trutwin
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/D

DELETE from more than one table

2004-06-07 Thread shaun thornburgh
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