That's why I always write a BEGIN statement before executing updates and deletes... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		kfrane on Nov 29, 2023 \| parent \| context \| favorite \| on: My $500M Mars rover mistake That's why I always write a BEGIN statement before executing updates and deletes. If they are not instant or don't return the expected number of modified rows I can just rollback the transaction.

groestl on Nov 29, 2023 [–]

That, and I start the line with /*, write the where clause first, and immediately before I execute the query I check the db host.

Oh, and I absolutely refuse to do anything but the most critical stuff against prod on Fridays.

Consider applying for YC's Winter 2026 batch! Applications are open till Nov 10
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact