Re:An administrator accidentally deleted the production data...
by was_boring on Wednesday March 23, 2016 @08:12AM
(#11343693)
My personal preference is to either have a "deleted_at" column so deletes never need to happen, or have a "history" table.
When this isn't possible, I do a select for the PK and delete based upon only the PK. This way I can review the rows to be deleted and back them up manually if needed.
All of this is way overkill considering the backups available these days.
When this isn't possible, I do a select for the PK and delete based upon only the PK. This way I can review the rows to be deleted and back them up manually if needed.
All of this is way overkill considering the backups available these days.