2 ms·
UPDATE also supports ORDER BY and LIMIT, which is kind of odd when you first see it.
by tyingq 5y ago
UPDATE also supports ORDER BY and LIMIT, which is kind of odd when you first see it.
- kwoff 5y agoSpeaking of LIMIT. Another potential "footgun", but with SELECT, is "select * from table limit1". Instead of limiting the number of rows to 1, you aliased the table as "limit1".