INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110101', '东城区', '110100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110102', '西城区', '110100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110103', '崇文区', '110100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110104', '宣武区', '110100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110105', '朝阳区', '110100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110106', '丰台区', '110100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110107', '石景山区', '110100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110108', '海淀区', '110100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110109', '门头沟区', '110100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110111', '房山区', '110100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110112', '通州区', '110100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110113', '顺义区', '110100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110114', '昌平区', '110100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110115', '大兴区', '110100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110116', '怀柔区', '110100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110117', '平谷区', '110100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110228', '密云县', '110200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('110229', '延庆县', '110200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120101', '和平区', '120100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120102', '河东区', '120100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120103', '河西区', '120100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120104', '南开区', '120100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120105', '河北区', '120100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120106', '红桥区', '120100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120107', '塘沽区', '120100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120108', '汉沽区', '120100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120109', '大港区', '120100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120110', '东丽区', '120100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120111', '西青区', '120100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120112', '津南区', '120100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120113', '北辰区', '120100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120114', '武清区', '120100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120115', '宝坻区', '120100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120221', '宁河县', '120200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120223', '静海县', '120200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('120225', '蓟 县', '120200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130101', '市辖区', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130102', '长安区', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130103', '桥东区', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130104', '桥西区', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130105', '新华区', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130107', '井陉矿区', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130108', '裕华区', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130121', '井陉县', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130123', '正定县', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130124', '栾城县', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130125', '行唐县', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130126', '灵寿县', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130127', '高邑县', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130128', '深泽县', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130129', '赞皇县', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130130', '无极县', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130131', '平山县', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130132', '元氏县', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130133', '赵 县', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130181', '辛集市', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130182', '藁城市', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130183', '晋州市', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130184', '新乐市', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130185', '鹿泉市', '130100');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130201', '市辖区', '130200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130202', '路南区', '130200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130203', '路北区', '130200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130204', '古冶区', '130200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130205', '开平区', '130200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130207', '丰南区', '130200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130208', '丰润区', '130200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130223', '滦 县', '130200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130224', '滦南县', '130200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130225', '乐亭县', '130200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130227', '迁西县', '130200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130229', '玉田县', '130200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130230', '唐海县', '130200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130281', '遵化市', '130200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130283', '迁安市', '130200');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130301', '市辖区', '130300');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130302', '海港区', '130300');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130303', '山海关区', '130300');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130304', '北戴河区', '130300');
INSERT INTO area
(`areaID`, `area`, `father`)
VALUES
('130321', '青龙满族
全国省市县mysql数据库脚本（好东西啊！）
4星 · 超过85%的资源 需积分: 12 6 浏览量
2008-09-02
20:56:20
上传
评论 1
收藏 27KB RAR 举报 
全国省市县mysql数据库.rar （3个子文件） 
全国省市县mysql数据库 
city.sql 34KB province.sql 3KB area.sql 310KB资源评论
own000072013-01-15哥，这个东西是很老的版本了，5分啊····- milaneuo2012-08-24数据是全的,但其实省市区的数据可以合并为一个表会更好
- liuzhengjiang19932014-09-28不是我所需要的 我需要省市县单独的数据表脚本 跟我需要的不同
