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

Programmer Humor

32430 readers
1089 users here now

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

Rules:

founded 5 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[โ€“] EmasXP@lemmy.world 4 points 1 year ago (1 children)

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.