Lets say I have 20 comments that are related to article_id 76
will I have t开发者_开发问答o count all the article ids that have an article_id 76
and then run a foreach loop for all the comments related to article 76 or can I delete all the comments related to that article using a query?
SELECT article_id FROM articles_comments WHERE article_id = 76
DELETE FROM articles_comments WHERE article_id = 76;
DELETE FROM articles_comments WHERE article_id = 76
Just one operation:
delete from article_comments where article_id = 76
No need for any looping.
This one query will delete all the comments related to article_id
76
DELETE FROM articles_comments
WHERE article_id = 76;
精彩评论