285
submitted 2 years ago by rr7@lemmy.world to c/programmerhumor@lemmy.ml
you are viewing a single comment's thread
view the rest of the comments
[-] cashews_win@lemmy.world 11 points 2 years ago

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

[-] EmasXP@lemmy.world 4 points 2 years 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 2 years 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
285 points (99.3% liked)

Programmer Humor

36903 readers
135 users here now

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

Rules:

founded 5 years ago
MODERATORS