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