mysql update limit 折半更新

mysql在用update更新数据时还不支持limit范围更新

mysql> update user set name='aa'  limit 2,2;

ERROR 1064 (42000): 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 '2' at line 1

mysql在更新时只能用limit限制更新的条 [LIMIT row_count] 

此时如果想折半更新只能先更新全部,而后再执行更新其中的半数

update name set name='aa' order by name ; (全部更新,注意排序列必不可少 count(*)=4)

update name set position='bb' order by name limit 2; (折半更新,注意排序列必不可少,否则会重复更新某些列count(*)=4)