Hacker News new | past | comments | ask | show | jobs | submit login

I think an improvement to SQL would be for insert/update/delete clauses to require a where clause and allow for something like 1=1 if you really intend to hit all rows. A safe but even more invasive would be requiring an end to the were clause as well (to prevent selecting a few but not all constraints).



I think this is true for mysql, at least for delete.




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

Search: