|Problems? Is your data what you think it is?|
Sane way of operating. It will also protect you fro the less obvious mistake of writing
delete from table where key > 0;
delete from table where key < 0;
which is only one key apart. I know someone else who did that.
This thread is not about errors someone else made, but I will still tell one from the recent past:
After months of preparing and exercising all the needed commands for the move of one production platform to a newer platform of a more modern architecture, someone (not in our company) issued the main "rsync" command (which also had a --delete) THE WRONG WAY AROUND and deleting two days of work. The restore from backup took 6 hours and regained 1˝ day of work.
Enjoy, Have FUN! H.Merijn