How I destroyed the company's DB (a stupid SQL mistake)

Re:How I destroyed the company's DB (a stupid SQL mistake) by Karellen on Monday January 01, 2024 @02:38PM (#38834672)

But... this query used

    UPDATE orders
    SET is_deleted = true

DELETE without WHERE wasn't part of the problem.

[ Parent | on HN ]

Re:How I destroyed the company's DB (a stupid SQL mistake) by awestroke on Monday January 01, 2024 @03:08PM (#38834904)

Good idea, let’s enforce WHERE on UPDATE as well

[ Parent | on HN ]