用Update更新满足Select嵌套语句的数据

2024-11-22 22:22:16
推荐回答(1个)
回答1:

update purchaseinfo a,(select max(id) as id from purchaseinfo) b set a.value='1000' where a.id=b.id