这个是表结构
– 用来更新人口数据,一个表,先分组求和。接着根据 parentId找到对应的areaId
UPDATE T_Area inner join (SELECT parentId,sum(renkou) sum from T_Area GROUP BY parentId limit 1,500)a on a.parentId=T_Area.areaId set T_Area.renkou =a.sum
不能用这句话
UPDATE T_Area set T_Area.renkou =a.sum from (SELECT parentId,sum(renkou) sum from T_Area GROUP BY parentId limit 1,500)a where a.parentId=T_Area.areaId
截取center中第一个“,”以后的内容并更新到lat字段中
UPDATE T_Area inner join (select areaId,SUBSTRING_INDEX(T_Area.center,’,’,-1) lat from T_Area)a on a.areaId = T_Area.areaId set T_Area.lat=a.lat