通过查出最大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)本文共 197 字，大约阅读时间需要 1 分钟。
通过查出最大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)转载于:https://www.cnblogs.com/jiduoduo/p/6400538.html