update table1 set a areaid= (select areaid from table2 where city =a.city)子查询的返回值好像不只一个吧?distinct
update table1 set a areaid= (select distinct areaid from table2 where city =a.city) update table1 set a areaid= (select areaid from table2 where city =a.city group by areaid)
select dstinct city, areaid
update table1 set a areaid= (select distinct areaid from table2 where city =a.city)
update table1 set a areaid= (select areaid from table2 where city =a.city)子查询的返回值好像不只一个吧?distinct
update table1 set a areaid= (select areaid from table2 where city =a.city group by areaid)