How to delete records from multiple table using single sql statement?

Hi Friends,

Today I am going to tell you that how you can delete records from 2 tables by using single query. It is not possible to delete records from multiple table using simple delete query, but you can achieve this by using join in your sql statement. Now I am going to give you a very simple example with two table.
1) Category (id, title)
2) Product (id, title , cat_id)
Note* :- cat_id in Product table is a join key for category.

Now I want to delete all category and their product which id is 2. then our query will be
“DELETE Category , Product FROM Category INNER JOIN Product ON Category .id = Product .cat_id WHERE (Category .id)=’2′”

Cheers 🙂

 

Share This Post

Recent Articles

Leave a Reply

ERROR: si-captcha.php plugin: GD image support not detected in PHP!

Contact your web host and ask them to enable GD image support for PHP.

ERROR: si-captcha.php plugin: imagepng function not detected in PHP!

Contact your web host and ask them to enable imagepng for PHP.

© 2018 Networkocean. All rights reserved. Site Admin · Entries RSS · Comments RSS
Powered by WordPress · Designed by Theme Junkie