burhankhan Posted February 18, 2007 Share Posted February 18, 2007 I have 3 tables. Structure is as follow: Table A ---------------- id record 1 abc 2 def 3 sdf Table B -------------- id Aid records 1 1 ddd 2 1 eee 3 2 3434 Table C ------------- id Bid records 1 1 dfsdf 2 1 sfsfs 3 2 s sdfs 4 2 sdfsf I want to delete from all tables as: WHERE tableA.id = 1 and tableB.Aid = tableA.id and TableC.Bid = tableB.id I tried many queries but can't find how to delete all in one query. Thanks Burhan Khan Link to comment https://forums.phpfreaks.com/topic/39021-delete-records-from-multiple-tables/ Share on other sites More sharing options...
worldworld Posted February 18, 2007 Share Posted February 18, 2007 Try this : $sql = "DELETE FROM t1, t2 USING t1, t2 WHERE t1.id = t2.id"; Link to comment https://forums.phpfreaks.com/topic/39021-delete-records-from-multiple-tables/#findComment-188030 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.