rr7 to Programmer Humor@lemmy.mlEnglish · 2 years agoI think I leave early todayimagemessage-square19linkfedilinkarrow-up1384arrow-down13
arrow-up1381arrow-down1imageI think I leave early todayrr7 to Programmer Humor@lemmy.mlEnglish · 2 years agomessage-square19linkfedilink
minus-squarecashews_winBannedlinkfedilinkEnglisharrow-up17·2 years ago“I didn’t put a WHERE clause in that DELETE statement”
minus-squareEmasXPlinkfedilinkEnglisharrow-up7·2 years agoAs a side note, DBeaver actually asks for confirmation if it thinks you are about to do something wonky. I think it’s quite telling just how common this mistake is. We’ve all been there
minus-squaremarcoslinkfedilinkEnglisharrow-up3·2 years agoUpdate and delete should require a where clause. You can always use true or 1 = 1, the gain from omitting it is minimal. The fact that no DBMS ever decided to implement this, not even as an option is quite distressing.
“I didn’t put a WHERE clause in that DELETE statement”
As a side note, DBeaver actually asks for confirmation if it thinks you are about to do something wonky. I think it’s quite telling just how common this mistake is. We’ve all been there
Update and delete should require a where clause. You can always use true or 1 = 1, the gain from omitting it is minimal.
The fact that no DBMS ever decided to implement this, not even as an option is quite distressing.