Re: combining deletes

[Roland Bouman]

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