Remix.run Logo
buro9 7 months ago

UPDATEs should require a WHERE clause too.

At which point we could just say all SQL should have a WHERE clause.

jaredsohn 7 months ago | parent | next [-]

I think SELECTs without WHERE clauses are fine

marcosdumay 7 months ago | parent [-]

But requiring them is fine too. Even more on Postrges, that has booleans.

ahoka 7 months ago | parent | prev [-]

And queries should start with WHERE.