UPDATEs should require a WHERE clause too. At which point we could just say all ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		buro9 on Dec 1, 2024 \| parent \| context \| favorite \| on: DELETEs Are Difficult UPDATEs should require a WHERE clause too. At which point we could just say all SQL should have a WHERE clause.

jaredsohn on Dec 1, 2024 | [–]

I think SELECTs without WHERE clauses are fine

marcosdumay on Dec 1, 2024 | | [–]

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

ahoka on Dec 1, 2024 | [–]

And queries should start with WHERE.

awestroke on Dec 1, 2024 | [–]

FROM, then WHERE, then SELECT

Jabbles on Dec 1, 2024 | | | [–]

Pipe Syntax In SQL

https://research.google/pubs/sql-has-problems-we-can-fix-the...

https://news.ycombinator.com/item?id=41338877

hamandcheese on Dec 1, 2024 | | | [–]

This is the way.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact