276
you are viewing a single comment's thread
view the rest of the comments
[-] cashews_win@lemmy.world 10 points 1 year ago

"I didn't put a WHERE clause in that DELETE statement"

[-] EmasXP@lemmy.world 4 points 1 year ago

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

[-] marcos@lemmy.world 3 points 1 year ago

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.

this post was submitted on 25 Jun 2023
276 points (99.3% liked)

Programmer Humor

32069 readers
2585 users here now

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

founded 5 years ago
MODERATORS