MYSQL UPDATE LIMIT 更新限制語句用法

MYSQL 更新時，要更新記錄中某個區間的資料，隻能用WHERE條件來限制了 ， 用 LIMIT隻能限制更新多少條！ 測試如下：

UPDATE user SET money = money + 10000 ORDER BY userid DESC LIMIT 5,20
           

上面這句測試了是錯誤的，MYSQL的UPDATE語句不能更新限制從第幾條到第幾條！

錯誤提示：#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '20' at line 1

隻能用下面這樣的語句了，要麼你就用where條件語句來限制了

UPDATE user SET money = money + 10000 ORDER BY userid DESC LIMIT 20