- 博客(0)
- 资源 (7)
- 收藏
- 关注
DM8_SQL语言使用手册.pdf
目录
第 1 章 结构化查询语言 DM_SQL 简介 ....................................................................1
1.1 DM_SQL 语言的特点 .....................................................................................................1
1.2 保留字与标识符 ............................................................................................................2
1.3 DM_SQL 语言的功能及语句 .........................................................................................2
1.4 DM_SQL 所支持的数据类型 .........................................................................................3
1.4.1 常规数据类型 ....................................................................................................3
1.4.2 位串数据类型 ....................................................................................................5
1.4.3 日期时间数据类型 ............................................................................................6
1.4.4 多媒体数据类型 ..............................................................................................10
1.5 DM_SQL 语言支持的表达式 .......................................................................................10
1.5.1 数值表达式 ......................................................................................................11
1.5.2 字符串表达式 ..................................................................................................13
1.5.3 时间值表达式 ..................................................................................................13
1.5.4 时间间隔值表达式 ..........................................................................................15
1.5.5 运算符的优先级 ..............................................................................................16
1.6 DM_SQL 语言支持的数据库模式 ...............................................................................17
第 2 章 手册中的示例说明 ......................................................................................18
2.1 示例库说明 ..................................................................................................................18
2.2 参考脚本 ......................................................................................................................26
2.2.1 创建示例库 ......................................................................................................26
2.2.2 创建模式及表 ..................................................................................................26
2.2.3 插入数据 ..........................................................................................................33
第 3 章 数据定义语句 ..............................................................................................50
3.1 数据库修改语句 ..........................................................................................................50
3.2 管理用户 ......................................................................................................................53
3.2.1 用户定义语句 ..................................................................................................53
3.2.2 修改用户语句 ..................................................................................................59
3.2.3 用户删除语句 ..................................................................................................62
3.3 管理模式 ......................................................................................................................63
3.3.1 模式定义语句 ..................................................................................................63
3.3.2 设置当前模式语句 ..........................................................................................65
3.3.3 模式删除语句 ..................................................................................................65
3.4 管理表空间 ..................................................................................................................66
3.4.1 表空间定义语句 ..............................................................................................66
3.4.2 修改表空间语句 ..............................................................................................67
3.4.3 表空间删除语句 ..............................................................................................69
3.4.4 表空间失效文件检查 ......................................................................................70
3.4.5 表空间失效文件恢复准备 ..............................................................................70
I
目录
3.4.6 表空间失效文件恢复 ......................................................................................70
3.5 管理 HTS 表空间 .........................................................................................................71
3.5.1 创建 HTS 表空间 .............................................................................................71
3.5.2 修改 HTS 表空间 .............................................................................................71
3.5.3 删除 HTS 表空间 .............................................................................................72
3.6 管理表 ..........................................................................................................................72
3.6.1 表定义语句 ......................................................................................................72
3.6.2 表修改语句 ....................................................................................................115
3.6.3 基表删除语句 .............................................................................................133
3.6.4 基表数据删除语句 ........................................................................................134
3.6.5 事务型 HUGE 表数据重整 ............................................................................134
3.7 管理索引 ....................................................................................................................135
3.7.1 索引定义语句 ................................................................................................135
3.7.2 索引修改语句 ................................................................................................140
3.7.3 索引删除语句 ................................................................................................142
3.8 管理位图连接索引 .....................................................................................................143
3.8.1 位图连接索引定义语句 ................................................................................143
3.8.2 位图连接索引删除语句 ................................................................................145
3.9 管理全文索引 ............................................................................................................145
3.9.1 全文索引定义语句 ........................................................................................145
3.9.2 全文索引修改语句 ........................................................................................146
3.9.3 全文索引删除语句 ........................................................................................147
3.10 管理空间索引 ..........................................................................................................148
3.11 管理数组索引 ..........................................................................................................148
3.11.1 数组索引定义语句 .....................................................................................149
3.11.2 数组索引修改语句 .....................................................................................149
3.11.3 数组索引使用 .............................................................................................149
3.11.4 数组索引删除语句 .....................................................................................151
3.12 管理序列 ..................................................................................................................151
3.12.1 序列定义语句 .............................................................................................151
3.12.2 序列修改语句 .............................................................................................154
3.12.3 序列删除语句 .............................................................................................156
3.13 管理 SQL 域 .............................................................................................................156
3.13.1 创建 DOMAIN...............................................................................................156
3.13.2 使用 DOMAIN...............................................................................................157
3.13.3 删除 DOMAIN...............................................................................................158
3.14 管理上下文 ..............................................................................................................158
3.14.1 创建上下文 ..................................................................................................158
3.14.2 删除上下文 ..................................................................................................160
3.15 管理目录 ..................................................................................................................161
3.15.1 创建目录 ......................................................................................................161
3.15.2 删除目录 ......................................................................................................161
3.16 设置当前会话 ..........................................................................................................162
3.16.1 时区信息 ......................................................................................................162
II
目录
3.16.2 日期串语言 ..................................................................................................162
3.16.3 日期串格式 ..................................................................................................163
3.17 注释语句 ..................................................................................................................163
3.18 设置 INI 参数 .........................................................................................................164
3.18.1 设置参数值 ..................................................................................................164
3.18.2 设置仅对当前会话起作用 ..........................................................................165
3.19 修改系统语句 ..........................................................................................................166
3.20 设置列、索引生成统计信息 ..................................................................................166
第 4 章 数据查询语句 ............................................................................................168
4.1 单表查询 ....................................................................................................................179
4.1.1 简单查询 ........................................................................................................179
4.1.2 带条件查询 ....................................................................................................180
4.1.3 集函数 ............................................................................................................183
4.1.4 分析函数 ........................................................................................................188
4.1.5 情况表达式 ....................................................................................................205
4.2 连接查询 ....................................................................................................................209
4.2.1 交叉连接 ........................................................................................................209
4.2.2 自然连接(NATURAL JOIN)......................................................................210
4.2.3 JOIN … USING............................................................................................210
4.2.4 JOIN…ON .......................................................................................................211
4.2.5 自连接 ............................................................................................................211
4.2.6 内连接(INNER JOIN)................................................................................212
4.2.7 外连接(OUTER JOIN)................................................................................213
4.3 子查询 ........................................................................................................................217
4.3.1 标量子查询 ....................................................................................................217
4.3.2 表子查询 ........................................................................................................218
4.3.3 派生表子查询 ................................................................................................221
4.3.4 定量比较 ........................................................................................................221
4.3.5 带 EXISTS 谓词的子查询 ...........................................................................222
4.3.6 多列表子查询 ................................................................................................223
4.4 WITH 子句 ................................................................................................................224
4.4.1 WITH FUNCTION 子句 ...............................................................................224
4.4.2 公用表表达式子句 ........................................................................................225
4.5 合并查询结果 .............................................................................................................227
4.6 GROUP BY 和 HAVING 子句 ....................................................................................229
4.6.1 GROUP BY 子句的使用 ...............................................................................229
4.6.2 ROLLUP 的使用 ............................................................................................230
4.6.3 CUBE 的使用 .................................................................................................231
4.6.4 GROUPING 的使用 .......................................................................................233
4.6.5 GROUPING SETS 的使用 ...........................................................................234
4.6.6 GROUPING_ID 的使用 ................................................................................235
4.6.7 GROUP_ID 的使用 .......................................................................................236
4.6.8 HAVING 子句的使用 ....................................................................................237
III
目录
4.7 ORDER BY 子句 ........................................................................................................237
4.8 FOR UPDATE 子句 ...................................................................................................238
4.9 TOP 子句 ....................................................................................................................240
4.10 LIMIT 限定条件 .....................................................................................................241
4.10.1 LIMIT 子句 ................................................................................................241
4.10.2 ROW_LIMIT 子句 ......................................................................................242
4.11 全文检索 ..................................................................................................................243
4.12 层次查询子句 ..........................................................................................................245
4.12.1 层次查询子句 .............................................................................................245
4.12.2 层次查询相关伪列 .....................................................................................246
4.12.3 层次查询相关操作符 .................................................................................246
4.12.4 层次查询相关函数 .....................................................................................246
4.12.5 层次查询层内排序 .....................................................................................246
4.12.6 层次查询的限制 .........................................................................................247
4.13 并行查询 ..................................................................................................................251
4.14 ROWNUM ....................................................................................................................252
4.15 数组查询 ..................................................................................................................253
4.16 查看执行计划与执行跟踪统计 .....
目录
第 7 章 物化视图 ....................................................................................................283
7.1 物化视图的定义 ....................................................................................................283
7.2 物化视图的修改 ....................................................................................................286
7.3 物化视图的删除 ....................................................................................................287
7.4 物化视图的更新 ....................................................................................................288
7.5 物化视图允许的操作 ...........................................................................................288
7.6 物化视图日志的定义 ...........................................................................................288
7.7 物化视图日志的删除 ...........................................................................................290
7.8 物化视图的限制 ....................................................................................................290
7.8.1 物化视图的一般限制 ....................................................................................290
7.8.2 物化视图的分类 ............................................................................................290
7.8.3 快速刷新通用约束 ........................................................................................291
7.8.4 物化视图信息查看 ........................................................................................291
第 8 章 函数 ............................................................................................................293
8.1 数值函数 ....................................................................................................................298
8.2 字符串函数 ................................................................................................................311
8.3 日期时间函数 ............................................................................................................332
8.4 空值判断函数 ............................................................................................................351
8.5 类型转换函数 ............................................................................................................352
8.6 杂类函数 ....................................................................................................................355
第 9 章 一致性和并发性 ........................................................................................358
9.1 DM 事务相关语句 ......................................................................................................358
9.1.1 事务的开始 ....................................................................................................358
9.1.2 事务的结束 ....................................................................................................358
9.1.3 保存点相关语句 ............................................................................................359
9.1.4 设置事务隔离级及读写特性 ........................................................................360
9.2 DM 手动上锁语句 ......................................................................................................361
第 10 章 外部函数 ..................................................................................................364
10.1 C 外部函数 ..............................................................................................................364
10.1.1 生成动态库 .................................................................................................364
10.1.2 C 外部函数创建 ..........................................................................................366
10.1.3 举例说明 .....................................................................................................367
10.2 JAVA 外部函数 .......................................................................................................369
10.2.1 生成 jar 包 ................................................................................................370
10.2.2 JAVA 外部函数创建 ..................................................................................370
10.2.3 举例说明 .....................................................................................................371
10.3 AP 使用说明 ............................................................................................................372
第 11 章 包 .............................................................................................................373
11.1 创建包 ......................................................................................................................373
V
目录
11.1.1 创建包规范 .................................................................................................373
11.1.2 创建包主体 .................................................................................................374
11.2 重编译包 ..................................................................................................................376
11.3 删除包 ......................................................................................................................376
11.3.1 删除包规范 .................................................................................................376
11.3.2 删除包主体 .................................................................................................377
11.4 应用实例 ..................................................................................................................377
第 12 章 类类型 ......................................................................................................381
12.1 普通 CLASS 类型 .....................................................................................................381
12.1.1 声明类 .........................................................................................................382
12.1.2 实现类 .........................................................................................................383
12.1.3 重编译类 .....................................................................................................385
12.1.4 删除类 .........................................................................................................386
12.1.5 类的使用 .....................................................................................................386
12.2 JAVA CLASS 类型 .................................................................................................388
12.2.1 定义 JAVA 类 ..............................................................................................389
12.2.2 重编译 JAVA 类 ..........................................................................................391
12.2.3 删除 JAVA 类 ..............................................................................................391
12.2.4 类的使用 .....................................................................................................391
第 13 章自定义类型 ................................................................................................393
13.1 创建类型 ..................................................................................................................393
13.2 创建类型体 ...............................................................................................................394
13.3 重编译类型 ...............................................................................................................395
13.4 删除类型 ...................................................................................................................395
13.4.1 删除类型 ......................................................................................................396
13.4.2 删除类型体 ..................................................................................................396
13.5 自定义类型的使用 ...................................................................................................396
13.5.1 使用规则 .....................................................................................................396
13.5.2 应用实例 .....................................................................................................396
第 14 章 触发器 ......................................................................................................398
14.1 触发器的定义 ..........................................................................................................398
14.1.1 表触发器 ......................................................................................................398
14.1.2 事件触发器 ..................................................................................................408
14.1.3 时间触发器 ..................................................................................................418
14.2 触发器替换 ..............................................................................................................419
14.3 设计触发器的原则 ...................................................................................................419
14.4 触发器的删除 ..........................................................................................................420
14.5 禁止和允许触发器 ..................................................................................................420
14.6 触发器的重编 ..........................................................................................................421
14.7 触发器应用举例 ......................................................................................................421
14.7.1 使用触发器实现审计功能 .........................................................................422
VI
目录
14.7.2 使用触发器维护数据完整性 ......................................................................422
14.7.3 使用触发器保障数据安全性 ......................................................................423
14.7.4 使用触发器生成字段默认值 ......................................................................424
第 15 章 同义词 ......................................................................................................426
15.1 创建同义词 ..............................................................................................................426
15.2 删除同义词 ..............................................................................................................427
第 16 章 外部链接 ..................................................................................................429
16.1 创建外部链接 ..........................................................................................................429
16.2 删除外部链接 ..........................................................................................................433
16.3 使用外部链接 ..........................................................................................................434
第 17 章 闪回查询 ..................................................................................................435
17.1 闪回查询子句 ..........................................................................................................435
17.2 闪回版本查询 ..........................................................................................................437
17.3 闪回事务查询 ..........................................................................................................439
第 18 章 JSON.........................................................................................................440
18.1 数据类型 ...................................................................................................................440
18.1.1 string......................................................................................................440
18.1.2 number......................................................................................................441
18.1.3 true、false...........................................................................................441
18.1.4 null...........................................................................................................443
18.1.5 object......................................................................................................444
18.1.6 array ........................................................................................................444
18.2 函数 ..........................................................................................................................444
18.2.1 json_value ............................................................................................444
18.2.2 json_query ............................................................................................445
18.2.3 函数参数详解 ...........................................................................................446
18.3 使用 IS JSON/IS NOT JSON 条件 ...................................................................448
18.4 视图 ...........................................................................................................................451
18.4.1 视图使用说明 ..............................................................................................451
18.4.2 DBA_JSON_COLUMNS................................................................................451
18.4.3 USER_JSON_COLUMNS .............................................................................452
18.4.4 ALL_JSON_COLUMNS................................................................................452
18.5 一个简单的例子 .......................................................................................................452
第 19 章 高级日志 ..................................................................................................455
19.1 简介 ..........................................................................................................................455
19.2 使用须知 ..................................................................................................................455
19.3 语法 ..........................................................................................................................455
19.3.1 管理日志辅助表 .........................................................................................455
19.3.2 使用日志辅助表的规则与约束 ..................................................................456
VII
目录
19.3.3 日志辅助表结构 .........................................................................................456
19.3.4 系统过程 .....................................................................................................457
19.4 使用高级日志同步数据的原则 ..............................................................................457
19.5 应用实例 ..................................................................................................................459
19.5.1 创建不带主键的源表 .................................................................................459
19.5.2 创建带主键的源表 .....................................................................................462
附录 1 关键字和保留字 .........................................................................................465
附录 2 SQL 语法描述说明 ....................................................................................469
附录 3 系统存储过程和函数 .................................................................................472
1) INI 参数管理 ..............................................................................................................472
2) 系统信息管理 ...............................................................................................................477
3) 备份恢复管理 ...............................................................................................................491
4) 定时器管理 ...................................................................................................................521
5) 数据复制管理 ...............................................................................................................524
6) 模式对象相关信息管理 ...............................................................................................533
7) 数据守护管理 ...............................................................................................................543
8) MPP 管理 ......................................................................................................................548
9) 日志与检查点管理 .......................................................................................................551
10) 数据库重演 ................................................................................................................552
11) 统计信息 ....................................................................................................................553
12) 资源监测 ....................................................................................................................560
13) 类型别名 ....................................................................................................................570
14) 杂类函数 ....................................................................................................................572
15) 编目函数调用的系统函数 .........................................................................................583
16) BFILE.........................................................................................................................593
17) HUGE 表备份还原 ......................................................................................................593
18) 定制会话级 INI 参数 ...............................................................................................595
19) 为 SQL 指定 HINT......................................................................................................597
20) 时区设置 ....................................................................................................................599
2019-08-05
2017更新后区划代码json
[
{
"value": "110000",
"label": "北京市",
"children": [
{
"value": "110100",
"label": "市辖区",
"children": [
{
"value": "110101",
"label": "东城区"
},
{
"value": "110102",
"label": "西城区"
},
{
"value": "110105",
"label": "朝阳区"
},
{
"value": "110106",
"label": "丰台区"
},
{
"value": "110107",
"label": "石景山区"
},
{
"value": "110108",
"label": "海淀区"
},
{
"value": "110109",
"label": "门头沟区"
},
{
"value": "110111",
"label": "房山区"
},
{
"value": "110112",
"label": "通州区"
},
{
"value": "110113",
"label": "顺义区"
},
{
"value": "110114",
"label": "昌平区"
},
{
"value": "110115",
"label": "大兴区"
},
{
"value": "110116",
"label": "怀柔区"
},
{
"value": "110117",
"label": "平谷区"
}
]
},
{
"value": "110200",
"label": "县",
"children": [
{
"value": "110228",
"label": "密云县"
},
{
"value": "110229",
"label": "延庆县"
}
]
}
]
},
{
"value": "120000",
"label": "天津市",
"children": [
{
"value": "120100",
"label": "市辖区",
"children": [
{
"value": "120101",
"label": "和平区"
},
{
"value": "120102",
"label": "河东区"
},
{
"value": "120103",
"label": "河西区"
},
{
"value": "120104",
"label": "南开区"
},
{
"value": "120105",
"label": "河北区"
},
{
"value": "120106",
"label": "红桥区"
},
{
"value": "120110",
"label": "东丽区"
},
{
"value": "120111",
"label": "西青区"
},
{
"value": "120112",
"label": "津南区"
},
{
"value": "120113",
"label": "北辰区"
},
{
"value": "120114",
"label": "武清区"
},
{
"value": "120115",
"label": "宝坻区"
},
{
"value": "120116",
"label": "滨海新区"
}
]
},
{
"value": "120200",
"label": "县",
"children": [
{
"value": "120221",
"label": "宁河县"
},
{
"value": "120223",
"label": "静海县"
},
{
"value": "120225",
"label": "蓟县"
}
]
}
]
},
{
"value": "130000",
"label": "河北省",
"children": [
{
"value": "130100",
"label": "石家庄市",
"children": [
{
"value": "130101",
"label": "市辖区"
},
{
"value": "130102",
"label": "长安区"
},
{
"value": "130104",
"label": "桥西区"
},
{
"value": "130105",
"label": "新华区"
},
{
"value": "130107",
"label": "井陉矿区"
},
{
"value": "130108",
"label": "裕华区"
},
{
"value": "130109",
"label": "藁城区"
},
{
"value": "130110",
"label": "鹿泉区"
},
{
"value": "130111",
"label": "栾城区"
},
{
"value": "130121",
"label": "井陉县"
},
{
"value": "130123",
"label": "正定县"
},
{
"value": "130125",
"label": "行唐县"
},
{
"value": "130126",
"label": "灵寿县"
},
{
"value": "130127",
"label": "高邑县"
},
{
"value": "130128",
"label": "深泽县"
},
{
"value": "130129",
"label": "赞皇县"
},
{
"value": "130130",
"label": "无极县"
},
{
"value": "130131",
"label": "平山县"
},
{
"value": "130132",
"label": "元氏县"
},
{
"value": "130133",
"label": "赵县"
},
{
"value": "130181",
"label": "辛集市"
},
{
"value": "130183",
"label": "晋州市"
},
{
"value": "130184",
"label": "新乐市"
}
]
},
{
"value": "130200",
"label": "唐山市",
"children": [
{
"value": "130201",
"label": "市辖区"
},
{
"value": "130202",
"label": "路南区"
},
{
"value": "130203",
"label": "路北区"
},
{
"value": "130204",
"label": "古冶区"
},
{
"value": "130205",
"label": "开平区"
},
{
"value": "130207",
"label": "丰南区"
},
{
"value": "130208",
"label": "丰润区"
},
{
"value": "130209",
"label": "曹妃甸区"
},
{
"value": "130223",
"label": "滦县"
},
{
"value": "130224",
"label": "滦南县"
},
{
"value": "130225",
"label": "乐亭县"
},
{
"value": "130227",
"label": "迁西县"
},
{
"value": "130229",
"label": "玉田县"
},
{
"value": "130281",
"label": "遵化市"
},
{
"value": "130283",
"label": "迁安市"
}
]
},
{
"value": "130300",
"label": "秦皇岛市",
"children": [
{
"value": "130301",
"label": "市辖区"
},
{
"value": "130302",
"label": "海港区"
},
{
"value": "130303",
"label": "山海关区"
},
{
"value": "130304",
"label": "北戴河区"
},
{
"value": "130321",
"label": "青龙满族自治县"
},
{
"value": "130322",
"label": "昌黎县"
},
{
"value": "130323",
"label": "抚宁县"
},
{
"value": "130324",
"label": "卢龙县"
}
]
},
{
"value": "130400",
"label": "邯郸市",
"children": [
{
"value": "130401",
"label": "市辖区"
},
{
"value": "130402",
"label": "邯山区"
},
{
"value": "130403",
"label": "丛台区"
},
{
"value": "130404",
"label": "复兴区"
},
{
"value": "130406",
"label": "峰峰矿区"
},
{
"value": "130421",
"label": "邯郸县"
},
{
"value": "130423",
"label": "临漳县"
},
{
"value": "130424",
"label": "成安县"
},
{
"value": "130425",
"label": "大名县"
},
{
"value": "130426",
"label": "涉县"
},
{
"value": "130427",
"label": "磁县"
},
{
"value": "130428",
"label": "肥乡县"
},
{
"value": "130429",
"label": "永年县"
},
{
"value": "130430",
"label": "邱县"
},
{
"value": "130431",
"label": "鸡泽县"
},
{
"value": "130432",
"label": "广平县"
},
{
"value": "130433",
"label": "馆陶县"
},
{
"value": "130434",
"label": "魏县"
},
{
"value": "130435",
"label": "曲周县"
},
{
"value": "130481",
"label": "武安市"
}
]
},
{
"value": "130500",
"label": "邢台市",
"children": [
{
"value": "130501",
"label": "市辖区"
},
{
"value": "130502",
"label": "桥东区"
},
{
"value": "130503",
"label": "桥西区"
},
{
"value": "130521",
"label": "邢台县"
},
{
"value": "130522",
"label": "临城县"
},
{
"value": "130523",
"label": "内丘县"
},
{
"value": "130524",
"label": "柏乡县"
},
{
"value": "130525",
"label": "隆尧县"
},
{
"value": "130526",
"label": "任县"
},
{
"value": "130527",
"label": "南和县"
},
{
"value": "130528",
"label": "宁晋县"
},
{
"value": "130529",
"label": "巨鹿县"
},
{
"value": "130530",
"label": "新河县"
},
{
"value": "130531",
"label": "广宗县"
},
{
"value": "130532",
"label": "平乡县"
},
{
"value": "130533",
"label": "威县"
},
{
"value": "130534",
"label": "清河县"
},
{
"value": "130535",
"label": "临西县"
},
{
"value": "130581",
"label": "南宫市"
},
{
"value": "130582",
"label": "沙河市"
}
]
},
{
"value": "130600",
"label": "保定市",
"children": [
{
"value": "130601",
"label": "市辖区"
},
{
"value": "130602",
"label": "新市区"
},
{
"value": "130603",
"label": "北市区"
},
{
"value": "130604",
"label": "南市区"
},
{
"value": "130621",
"label": "满城县"
},
{
"value": "130622",
"label": "清苑县"
},
{
"value": "130623",
"label": "涞水县"
},
{
"value": "130624",
"label": "阜平县"
},
{
"value": "130625",
"label": "徐水县"
},
{
"value": "130626",
"label": "定兴县"
},
{
"value": "130627",
"label": "唐县"
},
{
"value": "130628",
"label": "高阳县"
},
{
"value": "130629",
"label": "容城县"
},
{
"value": "130630",
"label": "涞源县"
},
{
"value": "130631",
"label": "望都县"
},
{
"value": "130632",
"label": "安新县"
},
{
"value": "130633",
"label": "易县"
},
{
"value": "130634",
"label": "曲阳县"
},
{
"value": "130635",
"label": "蠡县"
},
{
"value": "130636",
"label": "顺平县"
},
{
"value": "130637",
"label": "博野县"
},
{
"value": "130638",
"label": "雄县"
},
{
"value": "130681",
"label": "涿州市"
},
{
"value": "130682",
"label": "定州市"
},
{
"value": "130683",
"label": "安国市"
},
{
"value": "130684",
"label": "高碑店市"
}
]
},
{
"value": "130700",
"label": "张家口市",
"children": [
{
"value": "130701",
"label": "市辖区"
},
{
"value": "130702",
"label": "桥东区"
},
{
"value": "130703",
"label": "桥西区"
},
{
"value": "130705",
"label": "宣化区"
},
{
"value": "130706",
"label": "下花园区"
},
{
"value": "130721",
"label": "宣化县"
},
{
"value": "130722",
"label": "张北县"
},
{
"value": "130723",
"label": "康保县"
},
{
"value": "130724",
"label": "沽源县"
},
{
"value": "130725",
"label": "尚义县"
},
{
"value": "130726",
"label": "蔚县"
},
{
"value": "130727",
"label": "阳原县"
},
{
"value": "130728",
"label": "怀安县"
},
{
"value": "130729",
"label": "万全县"
},
{
"value": "130730",
"label": "怀来县"
},
{
"value": "130731",
"label": "涿鹿县"
},
{
"value": "130732",
"label": "赤城县"
},
{
"value": "130733",
"label": "崇礼县"
}
]
},
{
"value": "130800",
"label": "承德市",
"children": [
{
"value": "130801",
"label": "市辖区"
},
{
"value": "130802",
"label": "双桥区"
},
{
"value": "130803",
"label": "双滦区"
},
{
"value": "130804",
"label": "鹰手营子矿区"
},
{
"value": "130821",
"label": "承德县"
},
{
"value": "130822",
"label": "兴隆县"
},
{
"value": "130823",
"label": "平泉县"
},
{
"value": "130824",
"label": "滦平县"
},
{
"value": "130825",
"label": "隆化县"
},
{
"value": "130826",
"label": "丰宁满族自治县"
},
{
"value": "130827",
"label": "宽城满族自治县"
},
{
"value": "130828",
"label": "围场满族蒙古族自治县"
}
]
},
{
"value": "130900",
"label": "沧州市",
"children": [
{
"value": "130901",
"label": "市辖区"
},
{
"value": "130902",
"label": "新华区"
},
{
"value": "130903",
"label": "运河区"
},
{
"value": "130921",
"label": "沧县"
},
{
"value": "130922",
"label": "青县"
},
{
"value": "130923",
"label": "东光县"
},
{
"value": "130924",
"label": "海兴县"
},
{
"value": "130925",
"label": "盐山县"
},
{
"value": "130926",
"label": "肃宁县"
},
{
"value": "130927",
"label": "南皮县"
},
{
"value": "130928",
"label": "吴桥县"
},
{
"value": "130929",
"label": "献县"
},
{
"value": "130930",
"label": "孟村回族自治县"
},
{
"value": "130981",
"label": "泊头市"
},
{
"value": "130982",
"label": "任丘市"
},
{
"value": "130983",
"label": "黄骅市"
},
{
"value": "130984",
"label": "河间市"
}
]
},
{
"value": "131000",
"label": "廊坊市",
"children": [
{
"value": "131001",
"label": "市辖区"
},
{
"value": "131002",
"label": "安次区"
},
{
"value": "131003",
"label": "广阳区"
},
{
"value": "131022",
"label": "固安县"
},
{
"value": "131023",
"label": "永清县"
},
{
"value": "131024",
"label": "香河县"
},
{
"value": "131025",
"label": "大城县"
},
{
"value": "131026",
"label": "文安县"
},
{
"value": "131028",
"label": "大厂回族自治县"
},
{
"value": "131081",
"label": "霸州市"
},
{
"value": "131082",
"label": "三河市"
}
]
},
{
"value": "131100",
"label": "衡水市",
"children": [
{
"value": "131101",
"label": "市辖区"
},
{
"value": "131102",
"label": "桃城区"
},
{
"value": "131121",
"label": "枣强县"
},
{
"value": "131122",
"label": "武邑县"
},
{
"value": "131123",
"label": "武强县"
},
{
"value": "131124",
"label": "饶阳县"
},
{
"value": "131125",
"label": "安平县"
},
{
"value": "131126",
"label": "故城县"
},
{
"value": "131127",
"label": "景县"
},
{
"value": "131128",
"label": "阜城县"
},
{
"value": "131181",
"label": "冀州市"
},
{
"value": "131182",
"label": "深州市"
}
]
}
]
},
{
"value": "140000",
"label": "山西省",
"children": [
{
"value": "140100",
"label": "太原市",
"children": [
{
"value": "140101",
"label": "市辖区"
},
{
"value": "140105",
"label": "小店区"
},
{
"value": "140106",
"label": "迎泽区"
},
{
"value": "140107",
"label": "杏花岭区"
},
{
"value": "140108",
"label": "尖草坪区"
},
{
"value": "140109",
"label": "万柏林区"
},
{
"value": "140110",
"label": "晋源区"
},
{
"value": "140121",
"label": "清徐县"
},
{
"value": "140122",
"label": "阳曲县"
},
{
"value": "140123",
"label": "娄烦县"
},
{
"value": "140181",
"label": "古交市"
}
]
},
{
"value": "140200",
"label": "大同市",
"children": [
{
"value": "140201",
"label": "市辖区"
},
{
"value": "140202",
"label": "城区"
},
{
"value": "140203",
"label": "矿区"
},
{
"value": "140211",
"label": "南郊区"
},
{
"value": "140212",
"label": "新荣区"
},
{
"value": "140221",
"label": "阳高县"
},
{
"value": "140222",
"label": "天镇县"
},
{
"value": "140223",
"label": "广灵县"
},
{
"value": "140224",
"label": "灵丘县"
},
{
"value": "140225",
"label": "浑源县"
},
{
"value": "140226",
"label": "左云县"
},
{
"value": "140227",
"label": "大同县"
}
]
},
{
"value": "140300",
"label": "阳泉市",
"children": [
{
"value": "140301",
"label": "市辖区"
},
{
"value": "140302",
"label": "城区"
},
{
"value": "140303",
"label": "矿区"
},
{
"value": "140311",
"label": "郊区"
},
{
"value": "140321",
"label": "平定县"
},
{
"value": "140322",
"label": "盂县"
}
]
},
{
"value": "140400",
"label": "长治市",
"children": [
{
"value": "140401",
"label": "市辖区"
},
{
"value": "140402",
"label": "城区"
},
{
"value": "140411",
"label": "郊区"
},
{
"value": "140421",
"label": "长治县"
},
{
"value": "140423",
"label": "襄垣县"
},
{
"value": "140424",
"label": "屯留县"
},
{
"value": "140425",
"label": "平顺县"
},
{
"value": "140426",
"label": "黎城县"
},
{
"value": "140427",
"label": "壶关县"
},
{
"value": "140428",
"label": "长子县"
},
{
"value": "140429",
"label": "武乡县"
},
{
"value": "140430",
"label": "沁县"
},
{
"value": "140431",
"label": "沁源县"
},
{
"value": "140481",
"label": "潞城市"
}
]
},
{
"value": "140500",
"label": "晋城市",
"children": [
{
"value": "140501",
"label": "市辖区"
},
{
"value": "140502",
"label": "城区"
},
{
"value": "140521",
"label": "沁水县"
},
{
"value": "140522",
"label": "阳城县"
},
{
"value": "140524",
"label": "陵川县"
},
{
"value": "140525",
"label": "泽州县"
},
{
"value": "140581",
"label": "高平市"
}
]
},
{
"value": "140600",
"label": "朔州市",
"children": [
{
"value": "140601",
"label": "市辖区"
},
{
"value": "140602",
"label": "朔城区"
},
{
"value": "140603",
"label": "平鲁区"
},
{
"value": "140621",
"label": "山阴县"
},
{
"value": "140622",
"label": "应县"
},
{
"value": "140623",
"label": "右玉县"
},
{
"value": "140624",
"label": "怀仁县"
}
]
},
{
"value": "140700",
"label": "晋中市",
"children": [
{
"value": "140701",
"label": "市辖区"
},
{
"value": "140702",
"label": "榆次区"
},
{
"value": "140721",
"label": "榆社县"
},
{
"value": "140722",
"label": "左权县"
},
{
"value": "140723",
"label": "和顺县"
},
{
"value": "140724",
"label": "昔阳县"
},
{
"value": "140725",
"label": "寿阳县"
},
{
"value": "140726",
"label": "太谷县"
},
{
"value": "140727",
"label": "祁县"
},
{
"value": "140728",
"label": "平遥县"
},
{
"value": "140729",
"label": "灵石县"
},
{
"value": "140781",
"label": "介休市"
}
]
},
{
"value": "140800",
"label": "运城市",
"children": [
{
"value": "140801",
"label": "市辖区"
},
{
"value": "140802",
"label": "盐湖区"
},
{
"value": "140821",
"label": "临猗县"
},
{
"value": "140822",
"label": "万荣县"
},
{
"value": "140823",
"label": "闻喜县"
},
{
"value": "140824",
"label": "稷山县"
},
{
"value": "140825",
"label": "新绛县"
},
{
"value": "140826",
"label": "绛县"
},
{
"value": "140827",
"label": "垣曲县"
},
{
"value": "140828",
"label": "夏县"
},
{
"value": "140829",
"label": "平陆县"
},
{
"value": "140830",
"label": "芮城县"
},
{
"value": "140881",
"label": "永济市"
},
{
"value": "140882",
"label": "河津市"
}
]
},
{
"value": "140900",
"label": "忻州市",
"children": [
{
"value": "140901",
"label": "市辖区"
},
{
"value": "140902",
"label": "忻府区"
},
{
"value": "140921",
"label": "定襄县"
},
{
"value": "140922",
"label": "五台县"
},
{
"value": "140923",
"label": "代县"
},
{
"value": "140924",
"label": "繁峙县"
},
{
"value": "140925",
"label": "宁武县"
},
{
"value": "140926",
"label": "静乐县"
},
{
"value": "140927",
"label": "神池县"
},
{
"value": "140928",
"label": "五寨县"
},
{
"value": "140929",
"label": "岢岚县"
},
{
"value": "140930",
"label": "河曲县"
},
{
"value": "140931",
"label": "保德县"
},
{
"value": "140932",
"label": "偏关县"
},
{
"value": "140981",
"label": "原平市"
}
]
},
{
"value": "141000",
"label": "临汾市",
"children": [
{
"value": "141001",
"label": "市辖区"
},
{
"value": "141002",
"label": "尧都区"
},
{
"value": "141021",
"label": "曲沃县"
},
{
"value": "141022",
"label": "翼城县"
},
{
"value": "141023",
"label": "襄汾县"
},
{
"value": "141024",
"label": "洪洞县"
},
{
"value": "141025",
"label": "古县"
},
{
"value": "141026",
"label": "安泽县"
},
{
"value": "141027",
"label": "浮山县"
},
{
"value": "141028",
"label": "吉县"
},
{
"value": "141029",
"label": "乡宁县"
},
{
"value": "141030",
"label": "大宁县"
},
{
"value": "141031",
"label": "隰县"
},
{
"value": "141032",
"label": "永和县"
},
{
"value": "141033",
"label": "蒲县"
},
{
"value": "141034",
"label": "汾西县"
},
{
"value": "141081",
"label": "侯马市"
},
{
"value": "141082",
"label": "霍州市"
}
]
},
{
"value": "141100",
"label": "吕梁市",
"children": [
{
"value": "141101",
"label": "市辖区"
},
{
"value": "141102",
"label": "离石区"
},
{
"value": "141121",
"label": "文水县"
},
{
"value": "141122",
"label": "交城县"
},
{
"value": "141123",
"label": "兴县"
},
{
"value": "141124",
"label": "临县"
},
{
"value": "141125",
"label": "柳林县"
},
{
"value": "141126",
"label": "石楼县"
},
{
"value": "141127",
"label": "岚县"
},
{
"value": "141128",
"label": "方山县"
},
{
"value": "141129",
"label": "中阳县"
},
{
"value": "141130",
"label": "交口县"
},
{
"value": "141181",
"label": "孝义市"
},
{
"value": "141182",
"label": "汾阳市"
}
]
}
]
},
{
"value": "150000",
"label": "内蒙古自治区",
"children": [
{
"value": "150100",
"label": "呼和浩特市",
"children": [
{
"value": "150101",
"label": "市辖区"
},
{
"value": "150102",
"label": "新城区"
},
{
"value": "150103",
"label": "回民区"
},
{
"value": "150104",
"label": "玉泉区"
},
{
"value": "150105",
"label": "赛罕区"
},
{
"value": "150121",
"label": "土默特左旗"
},
{
"value": "150122",
"label": "托克托县"
},
{
"value": "150123",
"label": "和林格尔县"
},
{
"value": "150124",
"label": "清水河县"
},
{
"value": "150125",
"label": "武川县"
}
]
},
{
"value": "150200",
"label": "包头市",
"children": [
{
"value": "150201",
"label": "市辖区"
},
{
"value": "150202",
"label": "东河区"
},
{
"value": "150203",
"label": "昆都仑区"
},
{
"value": "150204",
"label": "青山区"
},
{
"value": "150205",
"label": "石拐区"
},
{
"value": "150206",
"label": "白云鄂博矿区"
},
{
"value": "150207",
"label": "九原区"
},
{
"value": "150221",
"label": "土默特右旗"
},
{
"value": "150222",
"label": "固阳县"
},
{
"value": "150223",
"label": "达尔罕茂明安联合旗"
}
]
},
{
"value": "150300",
"label": "乌海市",
"children": [
{
"value": "150301",
"label": "市辖区"
},
{
"value": "150302",
"label": "海勃湾区"
},
{
"value": "150303",
"label": "海南区"
},
{
"value": "150304",
"label": "乌达区"
}
]
},
{
"value": "150400",
"label": "赤峰市",
"children": [
{
"value": "150401",
"label": "市辖区"
},
{
"value": "150402",
"label": "红山区"
},
{
"value": "150403",
"label": "元宝山区"
},
{
"value": "150404",
"label": "松山区"
},
{
"value": "150421",
"label": "阿鲁科尔沁旗"
},
{
"value": "150422",
"label": "巴林左旗"
},
{
"value": "150423",
"label": "巴林右旗"
},
{
"value": "150424",
"label": "林西县"
},
{
"value": "150425",
"label": "克什克腾旗"
},
{
"value": "150426",
"label": "翁牛特旗"
},
{
"value": "150428",
"label": "喀喇沁旗"
},
{
"value": "150429",
"label": "宁城县"
},
{
"value": "150430",
"label": "敖汉旗"
}
]
},
{
"value": "150500",
"label": "通辽市",
"children": [
{
"value": "150501",
"label": "市辖区"
},
{
"value": "150502",
"label": "科尔沁区"
},
{
"value": "150521",
"label": "科尔沁左翼中旗"
},
{
"value": "150522",
"label": "科尔沁左翼后旗"
},
{
"value": "150523",
"label": "开鲁县"
},
{
"value": "150524",
"label": "库伦旗"
},
{
"value": "150525",
"label": "奈曼旗"
},
{
"value": "150526",
"label": "扎鲁特旗"
},
{
"value": "150581",
"label": "霍林郭勒市"
}
]
},
{
"value": "150600",
"label": "鄂尔多斯市",
"children": [
{
"value": "150601",
"label": "市辖区"
},
{
"value": "150602",
"label": "东胜区"
},
{
"value": "150621",
"label": "达拉特旗"
},
{
"value": "150622",
"label": "准格尔旗"
},
{
"value": "150623",
"label": "鄂托克前旗"
},
{
"value": "150624",
"label": "鄂托克旗"
},
{
"value": "150625",
"label": "杭锦旗"
},
{
"value": "150626",
"label": "乌审旗"
},
{
"value": "150627",
"label": "伊金霍洛旗"
}
]
},
{
"value": "150700",
"label": "呼伦贝尔市",
"children": [
{
"value": "150701",
"label": "市辖区"
},
{
"value": "150702",
"label": "海拉尔区"
},
{
"value": "150703",
"label": "扎赉诺尔区"
},
{
"value": "150721",
"label": "阿荣旗"
},
{
"value": "150722",
"label": "莫力达瓦达斡尔族自治旗"
},
{
"value": "150723",
"label": "鄂伦春自治旗"
},
{
"value": "150724",
"label": "鄂温克族自治旗"
},
{
"value": "150725",
"label": "陈巴尔虎旗"
},
{
"value": "150726",
"label": "新巴尔虎左旗"
},
{
"value": "150727",
"label": "新巴尔虎右旗"
},
{
"value": "150781",
"label": "满洲里市"
},
{
"value": "150782",
"label": "牙克石市"
},
{
"value": "150783",
"label": "扎兰屯市"
},
{
"value": "150784",
"label": "额尔古纳市"
},
{
"value": "150785",
"label": "根河市"
}
]
},
{
"value": "150800",
"label": "巴彦淖尔市",
"children": [
{
"value": "150801",
"label": "市辖区"
},
{
"value": "150802",
"label": "临河区"
},
{
"value": "150821",
"label": "五原县"
},
{
"value": "150822",
"label": "磴口县"
},
{
"value": "150823",
"label": "乌拉特前旗"
},
{
"value": "150824",
"label": "乌拉特中旗"
},
{
"value": "150825",
"label": "乌拉特后旗"
},
{
"value": "150826",
"label": "杭锦后旗"
}
]
},
{
"value": "150900",
"label": "乌兰察布市",
"children": [
{
"value": "150901",
"label": "市辖区"
},
{
"value": "150902",
"label": "集宁区"
},
{
"value": "150921",
"label": "卓资县"
},
{
"value": "150922",
"label": "化德县"
},
{
"value": "150923",
"label": "商都县"
},
{
"value": "150924",
"label": "兴和县"
},
{
"value": "150925",
"label": "凉城县"
},
{
"value": "150926",
"label": "察哈尔右翼前旗"
},
{
"value": "150927",
"label": "察哈尔右翼中旗"
},
{
"value": "150928",
"label": "察哈尔右翼后旗"
},
{
"value": "150929",
"label": "四子王旗"
},
{
"value": "150981",
"label": "丰镇市"
}
]
},
{
"value": "152200",
"label": "兴安盟",
"children": [
{
"value": "152201",
"label": "乌兰浩特市"
},
{
"value": "152202",
"label": "阿尔山市"
},
{
"value": "152221",
"label": "科尔沁右翼前旗"
},
{
"value": "152222",
"label": "科尔沁右翼中旗"
},
{
"value": "152223",
"label": "扎赉特旗"
},
{
"value": "152224",
"label": "突泉县"
}
]
},
{
"value": "152500",
"label": "锡林郭勒盟",
"children": [
{
"value": "152501",
"label": "二连浩特市"
},
{
"value": "152502",
"label": "锡林浩特市"
},
{
"value": "152522",
"label": "阿巴嘎旗"
},
{
"value": "152523",
"label": "苏尼特左旗"
},
{
"value": "152524",
"label": "苏尼
2019-05-14
PyOpenGL-3.1.2-cp34-cp34m-win_amd64.whl
PyOpenGL-3.1.2-cp34-cp34m-win_amd64.whlPyOpenGL-3.1.2-cp34-cp34m-win_amd64.whl,python3.4
2018-09-27
PyQt5-5.4.1-gpl-Py3.4-Qt5.4.1-x64
PyQt5-5.4.1-gpl-Py3.4-Qt5.4.1-x64 ,Python3.4适用Python3.4适用
2018-09-27
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人