3 ms·
UPDATEs should require a WHERE clause too. At which point we could just say all SQL should have a WHERE clause.
by buro9 2y ago
UPDATEs should require a WHERE clause too.
At which point we could just say all SQL should have a WHERE clause.
- jaredsohn 2y agoI think SELECTs without WHERE clauses are fine
- marcosdumay 2y agoBut requiring them is fine too. Even more on Postrges, that has booleans.
- ahoka 2y agoAnd queries should start with WHERE.
- awestroke 2y agoFROM, then WHERE, then SELECT
- hamandcheese 2y agoThis is the way.
- Jabbles 2y agoPipe Syntax In SQL https://research.google/pubs/sql-has-problems-we-can-fix-them-pipe-syntax-in-sql/ https://research.google/pubs/sql-has-problems-we-can-fix-the... https://news.ycombinator.com/item?id=41338877 https://news.ycombinator.com/item?id=41338877
- deleted 2y ago[deleted]