MySQL Deleting rows from the database?

You could adjust the first method to do also not do the inserts on tags that already exist. But it could (and probably will) still result in more queries then the second method, especially if you combine those insert statements in a single query small example :) INSERT INTO content_tags (content_id, tag_id) VALUES (1,1), (1,2), (1,3).

You could adjust the first method to do also not do the inserts on tags that already exist. But it could (and probably will) still result in more queries then the second method, especially if you combine those insert statements in a single query. //small example :) INSERT INTO content_tags (content_id, tag_id) VALUES (1,1), (1,2), (1,3).

For example, let's say you have tag_id 1,3,5,7,9 stored for content_id 10. Now I go to update the tags and remove 3 and 5, so tag_id is now 1,7,9.So of course I need to delete tag_id 3 and 5, but I'd need to use php to compare them when it's much easier just to delete all the tags 1,3,5,7,9 and then just insert 1,7,9 instead. I'm just wondering if it's bad for the database to do this?

– Joker Feb 10 at 17:38 @Joker, I don't think it matters. Databases are basically made for these kinds of operations. So I don't think you have to worry about doing stuff that is bad for the database through regular queries.

If you start manipulating the database through File Manipulation then you should start worrying about damaging the database. – gnur Feb 10 at 20:55 Thanks for the confirmation, I'm now going to use the 2nd way ease. :) – Joker Feb 10 at 22:30.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.