delete records from multiple tables

[burhankhan]

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

[worldworld]

Try this :

$sql = "DELETE FROM t1, t2 USING t1, t2 WHERE t1.id = t2.id";