Comment

Comment on I accidentally removed the WHERE clause from my SQL query in a personal tool. Every row is now the same. I lost everything, have no backup, and I'm stupid.

towerful@programming.dev ⁨1⁩ ⁨year⁩ ago

PG has a useful extension, pg_safeupdate

github.com/eradman/pg-safeupdate

It helps reduce these possibilities by requiring a where clause for updates or deletes.
I guess if you get into a habit of adding where 1=1 to the end of your SQL, it kind of defeats the purpose.

source

Sort:hotnew top

myersguy@lemmy.simpl.website ⁨1⁩ ⁨year⁩ ago
MySQL (and by extension, MariaDB) has an even better option:

mysql --i-am-a-dummy

source
- tau@lemmings.world ⁨1⁩ ⁨year⁩ ago
  Amazing! These are going in my.conf ASAP.
  
  source
fmstrat@lemmy.nowsci.com ⁨1⁩ ⁨year⁩ ago
Transactions help more, IMO. The 1=1 becomes a real habit.

source