MySQL Forums
Forum List  »  Newbie

Re: Delete records from multiple tables in a single query
Posted by: Srinivasan T
Date: October 10, 2008 11:51AM

Murali,

Please give a try as follows :

delete a.*, b.* from table1 as a, table2 as b where a.id=b.table1id and a.id=1;

Regards,
Srini.

Options: ReplyQuote


Subject
Written By
Posted
Re: Delete records from multiple tables in a single query
October 10, 2008 11:51AM


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.