multi-table-delete

How to delete rows from tables which is referenced each other?

I want to do this: delete from table1 a,table2 b, table3 c where a.col1 = b.col1 and b.col2 = c.col2 and a.co3 <> 8001; But its giving me an error. ...

can i delete rows from 2 tables in one single SQL statement?

Hi there. I have 2 tables one called "REVIEW" and the other "REVIEW_DESCRIPTION" if i do a join to get all the data from both: SELECT * FROM reviews INNER JOIN reviews_description ON reviews.reviews_id=reviews_description.reviews_id WHERE reviews.customers_id = 54183 based on this i would like to delete rows in both tables that mat...

Multiple delete in a single query.

Hi, DELETE FROM Table1 WHERE ConditionID=?ConditionID; DELETE FROM Table2 WHERE ConditionID=?ConditionID; DELETE FROM Table3 WHERE ConditionID=?ConditionID; ConditionID is a column present in Table1,Table2,Table3, instead of running 3 times individually, is there a way to run all the three in a single query(in mysql)? Thanks. ...

delete from table1,table2,table3 where?

Hi there, If all tables I want to delete from have the column gamer_id can i do a delete from table1, table2, table3 where gamer_id = 123? or is there a different syntax? ...