MYSQL help
Posted: Thu Jan 20, 2011 8:47 am
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:
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
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 = ?;
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