mysql中子查询更新,得用别名表

通过查出最大id,来更新记录

update order set status = 'xx' where id in (select v.id from
(select max(id) id from x_order where device_id='000000' and uid=1)v)

posted @ 2017-02-15 11:03  jiduoduo  阅读(816)  评论(0编辑  收藏  举报