对id取余并且更新指定余数的的记录 update el_firm set addadmin = 8 where (id%5) = 0 转载于:https://my.oschina.net/u/3268486/blog/1823694