Delete from multiple tables in MySQL with one query

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

http://stackoverflow.com/questions/3331992/how-to-delete-from-multiple-tables-in-mysql — Doon, Sep 21 '14 at 03:26
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, Sep 21 '14 at 13:58

score 0 · Answer 1 · edited Sep 21 '14 at 03:59

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;

edited Sep 21 '14 at 03:59

reptildarat

answered Sep 21 '14 at 03:52

Chatz

1 Answers1