2 ms·
> A particularly nasty aspect of SQL UPDATE syntax is the predicate order, i.e. SET is before WHERE. Given the annoyance of this and its ability to really, rea
by zimpenfish 5y ago
> A particularly nasty aspect of SQL UPDATE syntax is the predicate order, i.e. SET is before WHERE.
Given the annoyance of this and its ability to really, really ruin your day, I don't know why someone hasn't updated their parser to allow 'update X where [cond] set [blah]' as an alternate phrasing.