先联表,后修改
例:
update bb as inte inner join item as item on inte.order_item_id = item.id set inte.pay_type = item.pay_type
sql联表修改篇
最新推荐文章于 2023-09-20 15:31:03 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)
先联表,后修改
例:
update bb as inte inner join item as item on inte.order_item_id = item.id set inte.pay_type = item.pay_type