update people s set city_name = (select name from city where code = s.city_code);
mySQL:两表更新(用一个表更新另一个表)的SQL语句
最新推荐文章于 2023-05-24 13:48:08 发布
update people s set city_name = (select name from city where code = s.city_code);