UPDATE bus_barrier_free_apply a INNER JOIN(
SELECT b.nation,b.cellphone,b.residence_address,b.identity_card from base_disable b WHERE b.`identity_card`IN('1','2','3','4','5','6','7','8','9','10')) c
ON a.identity_card= c.identity_card SET a.nation = c.nation, a.phone = c.cellphone, a.residence_address= c.residence_address;
MYSQL查询出的数据 进行修改
最新推荐文章于 2023-11-08 13:33:28 发布