News for hackers. Stuff that matters.
Re:Did Pixar accidentally delete Toy Story 2 during producti... by scriptman on Tuesday January 17, 2017 @08:07PM (#13423144)
I do a select first using the where clause I intend to use to get the row count.

Then open a transaction around the update with that same where clause, check the total number of rows updated matches the earlier select, then commit.

This approach definitely reduces your level of anxiety when working on a critical database.

There are no comments on this comment yet.