通过查出最大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)
jiduoduo 2017-02-15 11:03 原文
通过查出最大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)