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

I really hate that SQL doesn't let you do

   UPDATE counters WHERE name LIKE 'prefix.%' SET value = value + 1
In a SELECT it's fine, but in a mutation it's dangerous to make updating literally everything so easy if you leave off the tail.


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

Search: