⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 tb_area.sql

📁 《全国政区数据表》 SQL文档
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140829', '平陆县', '1408', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140830', '芮城县', '1408', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140881', '永济市', '1408', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140882', '河津市', '1408', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1409', '忻州', '14', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140901', '市辖区', '1409', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140902', '忻府区', '1409', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140921', '定襄县', '1409', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140922', '五台县', '1409', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140923', '代  县', '1409', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140924', '繁峙县', '1409', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140925', '宁武县', '1409', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140926', '静乐县', '1409', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140927', '神池县', '1409', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140928', '五寨县', '1409', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140929', '岢岚县', '1409', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140930', '河曲县', '1409', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140931', '保德县', '1409', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140932', '偏关县', '1409', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140981', '原平市', '1409', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1410', '临汾', '14', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141001', '市辖区', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141002', '尧都区', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141021', '曲沃县', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141022', '翼城县', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141023', '襄汾县', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141024', '洪洞县', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141025', '古  县', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141026', '安泽县', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141027', '浮山县', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141028', '吉  县', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141029', '乡宁县', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141030', '大宁县', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141031', '隰  县', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141032', '永和县', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141033', '蒲  县', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141034', '汾西县', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141081', '侯马市', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('141082', '霍州市', '1410', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1423', '吕梁地区', '14', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('142301', '孝义市', '1423', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('142302', '离石市', '1423', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('142303', '汾阳市', '1423', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('142322', '文水县', '1423', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('142323', '交城县', '1423', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('142325', '兴  县', '1423', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('142326', '临  县', '1423', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('142327', '柳林县', '1423', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('142328', '石楼县', '1423', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('142329', '岚  县', '1423', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('142330', '方山县', '1423', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('142332', '中阳县', '1423', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('142333', '交口县', '1423', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('15', '内蒙古', '0001', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1501', '呼和浩特', '15', 1, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150101', '市辖区', '1501', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150102', '新城区', '1501', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150103', '回民区', '1501', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150104', '玉泉区', '1501', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150105', '赛罕区', '1501', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150121', '土默特左旗', '1501', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150122', '托克托县', '1501', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150123', '和林格尔县', '1501', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150124', '清水河县', '1501', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150125', '武川县', '1501', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1502', '包头', '15', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150201', '市辖区', '1502', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150202', '东河区', '1502', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150203', '昆都伦区', '1502', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150204', '青山区', '1502', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150205', '石拐区', '1502', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150206', '白云矿区', '1502', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150207', '九原区', '1502', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150221', '土默特右旗', '1502', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150222', '固阳县', '1502', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150223', '达尔罕茂明安联合旗', '1502', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1503', '乌海', '15', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150301', '市辖区', '1503', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150302', '海勃湾区', '1503', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150303', '海南区', '1503', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('150304', '乌达区', '1503', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1504', '赤峰', '15', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentA
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -