• EmasXP@lemmy.world
    link
    fedilink
    English
    arrow-up
    4
    ·
    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
      link
      fedilink
      English
      arrow-up
      3
      ·
      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.