导入到 25city_csv 表中
SELECT `cityName`,`citycode`,`districtName`,`regionName`,`cname`,`id`,`1`,
SUM(CASE `mon` WHEN '201901' THEN `pricepingmi` ELSE 0 END) AS '201901',
SUM(CASE `mon` WHEN '201902' THEN pricepingmi ELSE 0 END) AS '201902',
SUM(CASE `mon` WHEN '201903' THEN pricepingmi ELSE 0 END) AS '201903',
SUM(CASE `mon` WHEN '201904' THEN pricepingmi ELSE 0 END) AS '201904' ,
SUM(CASE `mon` WHEN '201905' THEN pricepingmi ELSE 0 END) AS '201905' ,
SUM(CASE `mon` WHEN '201906' THEN pricepingmi ELSE 0 END) AS '201906'
FROM `25city_csv`
GROUP BY `cityName`,`citycode`,`districtName`,`regionName`,`cname`,`id` LIMIT 500000
