284
you are viewing a single comment's thread
view the rest of the comments
[-] 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
284 points (99.3% liked)

Programmer Humor

32365 readers
298 users here now

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

Rules:

founded 5 years ago
MODERATORS