mobile表结构如上:
实现根据color排序,取出top20,然后更新level为M
具体sql如下:
update mobile set
level=( SELECT "M" from (select id from mobile order by color limit 20) as m where mobile.id=id )
mobile表结构如上:
实现根据color排序,取出top20,然后更新level为M
具体sql如下:
update mobile set
level=( SELECT "M" from (select id from mobile order by color limit 20) as m where mobile.id=id )