3 ms·

UPDATE cashouts SET amount=0.00 <Accidental ENTER> Oops. That was missing a 'WHERE user_id=X'. Did not lose the client at the time (this was 15+ years ago),

UPDATE cashouts SET amount=0.00 <Accidental ENTER> Oops. That was missing a 'WHERE user_id=X'. Did not lose the client at the time (this was 15+ years ago), but that was a rough month. Haven't made that mistake again. It happens to all of us at some point though.

h1d 9y ago
I'm beginning to think this is a flaw in SQL. It's so easy to bust the entire table. Could've had something like 'UPDATE ALL' required for queries without filtering.
- blibble 9y ago
  just run BEGIN TRANSACTION before