Delete record where from multi table when it doesn't exist in table

Asked May 23 '17 at 10:43

Active May 23 '17 at 14:24

Viewed 59 times

I have 3 tables.

I need to delete all records from sub1T and sub2T in one SQL command.

I know how to delete all records inside sub1T using this command:

DELETE FROM `sub1T` 
WHERE NOT EXISTS (SELECT NULL 
                  FROM mainT 
                  WHERE `mainT`.main_id = main_id)

I need to delete from multiple child tables

edited May 23 '17 at 14:24

asked May 23 '17 at 10:43

Just E

I don't think you can delete from multiple tables in one command. You need to write PL/SQL for that. – Srihari Karanth May 23 '17 at 10:56
Most RDBMS support `on delete cascade`, which will delete data from child tables, when parent is deleted. For current requirement, you should use `2` `delete` statements and then try to implement `on delete cascade` on current table structure. – Utsav May 23 '17 at 10:57
1

Possible duplicate of [MySQL delete row from multiple tables](https://stackoverflow.com/questions/2214433/mysql-delete-row-from-multiple-tables) – Alexander May 23 '17 at 11:17
we cant do this in simple sql command – Just E May 30 '17 at 21:10

0 Answers0