this post was submitted on 25 Jun 2023
380 points (99.2% liked)

Programmer Humor

32710 readers
1193 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 7 points 2 years 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 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.