Delete records in two tables

ghjk

I have mysql db. there are tow tables. Per one record in first tables, has many record in second table.
Ex: table 1

Expand|Select|Wrap|Line Numbers

 
IDT1       name

===    =====

1        Animals

2        Vehicles

3        Fruits

Table 2

Expand|Select|Wrap|Line Numbers

 
IDT2      IDT1          des

===       ====        =====

a            1           cat

b             2           car

c             1           dog

If user delete 1 row in table 1 , should delete 1st and 3rd row in second table. How can I do that?

paulrajj

Expand|Select|Wrap|Line Numbers

  
DELETE t.*, a.* FROM table1 AS t LEFT JOIN

           table2 AS a ON t.idt1 = a.idt1 WHERE t.idt1 = 1

hope it helps.

Delete records in two tables

re: Delete records in two tables

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about