Page 1 of 1

MYSQL help

Posted: Thu Jan 20, 2011 8:47 am
by DanHardy
Hi all,

I have the following mysql delete query that essentially deletes a row from two seperate tables "messages" and "messages2" where the id is equal to that in both of the tables. The problem I am getting (for obvious reasons) is that it will only delete from the table, if it indeed exists in both tables.

Here is the query:

Code: Select all

DELETE FROM messages,messages2 USING messages,messages2 WHERE messages.id = messages2.id AND messages.id = ?;
How would I go about setting it so that the query always deletes from table "messages" and only deletes from "messages2" when a corresponding id exists?

I think it would involve an IF EXISTS clause, but I am not sure on this, or indeed how to implement it.

Thanks in advance guys

Dan