mysql合并到区间_mysql一些应用（坐标，检索，合并，分组，针对身份证）

获取某表内的坐标信息

CREATE TABLE demo1 select * FROM (

SELECT tzz_csyygl_v_his_citycases.CENTER_X,tzz_csyygl_v_his_citycases.CENTER_Y FROM tzz_csyygl_v_his_citycases ) A

select * FROM demo1

针对某表的数据进行检索分组

SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES

WHERE table_schema = 'data_aggregation' GROUP BY table_schema;

合并需要选择的字段

SELECT AREANAME,COUNT(*)

FROM zfw_wgh_v_ldpeo

GROUP BY AREANAME

笔记：select 列名，count(*)

From 表名

Group by 列名

对省份分组

select case

when province_no='11' then '北京市'

when province_no='12' then '天津市'

when province_no='13' then '河北省'

when province_no='14' then '山西省'

when province_no='15' then '内蒙古自治区'

when province_no='21' then '辽宁省'

when province_no='22' then '吉林省'

when province_no='23' then '黑龙江省'

when province_no='31' then '上海市'

when province_no='32' then '江苏省'

when province_no='33' then '浙江省'

when province_no='34' then '安徽省'

when province_no='35' then '福建省'

when province_no='36'