mysql用表A去查询表B的数据并更新到表A中
update know_10 s set jdids = (select arrparentid from category where catid = s.jdis);
原语句:
update people s set city_name = (select name from city where code = s.city_code);
mysql用表A去查询表B的数据并更新到表A中
update know_10 s set jdids = (select arrparentid from category where catid = s.jdis);
原语句:
update people s set city_name = (select name from city where code = s.city_code);