Delete from multiple tables in MySQL with one query [duplicate]

Question

I'm running into a problem with deleting from multiple tables.

DELETE FROM categories, products
WHERE categories.category_id = products.category_id 
    AND categories.category_id = 4;

Can anyone spot the mistake that I've made? I'm getting the errorcode: 1064

it appears that you need to explicitly declare the join, Did you look at the linked question? save for the table name it appears to be exactly what you are trying to do. — Doon
– Doon, Commented Sep 21, 2014 at 13:58

reptildarat · Accepted Answer · 2014-09-21 03:59:12Z

0

you can make the foreign key on product table as on delete cascade. Then, when you delete category product table references will also be deleted

DELETE FROM categories WHERE  
   categories.category_id = 4;

reptildarat

1,0362 gold badges18 silver badges35 bronze badges

answered Sep 21, 2014 at 3:52

Chatz

3482 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1