Jump to content

delete records from multiple tables


burhankhan

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.