Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Did Pixar accidentally delete Toy Story 2 during production? (2012). Parent comment
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.
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.