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