DELETE, INSERT and UPDATE || INSERT
If most of the data changes and there is no need for consistency checks, rollbacks, etc., table truncation will be most efficient. And then insert everything again.
The best solution depends on your circumstances and requirements. However, generally, I would not recommend dropping the table entirely.
source to share
Definitely to update existing values ββin the table.
You shouldn't drop the table often and recreate it just to change some values.
You should use insert, update and delete to insert new values ββinto the table, update any existing ones that have changed, and delete those you no longer need. If you really want to clear the table, you can do "delete from [tablename]" without the where clause and clear all values ββfrom the table, but don't delete the entire table or recreate it.
source to share
Depending on what you need ... a full clean / replace works just fine if you only want a "live" data body, active records only, for example.
Now, if you want history, you will need to follow the update / insert route, but any inactive records will require a flag pointing to such.
I would almost always choose the update / insert method, since you don't lose any data, and the moment you don't have it, that's when someone needs it.
source to share