delete rows not updated

Is there an easy way to delete all rows not updated when done updating a db?

What in the world do you mean?

Hard to answer a question without any details or context to what you're doing. :slight_smile:

Jeff purpleworkshops.com

I have a table of data that I update with a file. I would like to delete all data that does not get updated.

We've done stuff like this before. One pattern that we used was:

1) At the beginning of the import process, we'd set a unique value (like a timestamp/date) 2) We'd update an attribute in the table for all records with that value:

example: last_import = 20081231

3) then run your import/update process.. 4) then delete any records that last_import != 20081231

voila!

Robby