UPDATE emergency_supplies_equipment e1,emergency_supplies_warehouse e2 SET
e1.belong_warehouse=e2.wid WHERE e1.belong_warehouse=e2.wh_name
mysql通过对比一张表的数据来修改另一张表sql
最新推荐文章于 2024-04-03 17:19:24 发布
UPDATE emergency_supplies_equipment e1,emergency_supplies_warehouse e2 SET
e1.belong_warehouse=e2.wid WHERE e1.belong_warehouse=e2.wh_name