MySQL Forums
Forum List  »  InnoDB

Re: combining deletes
Posted by: Roland Bouman
Date: June 30, 2005 06:36PM

Not a transaction post. Anyway,

It really depends wheter some_random_table is really the same some_random_table for each of you deletes. If it is, simpy use:

DELETE FROM some_random_table WHERE a in (1,2)

By the way, why do you need the ORDER BY?

If your example would be something more like

DELETE FROM some_random_table1 WHERE a = 1
DELETE FROM some_random_table2 WHERE a = 2

you could have a go at the multiple table delete syntax. Unfortunately, it depends on wheter you run mysql 4.0.1 or 4.0.2 what syntax is supported.
see the manual 13.1

Kind Regards, Roland

Options: ReplyQuote

Written By
June 09, 2005 08:54PM
Re: combining deletes
June 30, 2005 06:36PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.