Mysql 两张表根据关联字段 同步其它字段
update people s set city_name = (select name from city where code = s.city_code);
主流方式
update people s, city c set s.city_name = c.name
where s.city_code = c.code
Mysql 两张表根据关联字段 同步其它字段
update people s set city_name = (select name from city where code = s.city_code);
主流方式
update people s, city c set s.city_name = c.name
where s.city_code = c.code