中国省份和城市数据(mysql数据库)

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50523 Source Host : localhost:3306 Source Database : customer_groupwill Target Server Type : MYSQL Target Server Version : 50523 File Encoding : 65001 Date: 2012-06-20 13:58:21 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `dict_city` -- ---------------------------- DROP TABLE IF EXISTS `dict_city`; CREATE TABLE `dict_city` ( `N_CITYID` int(10) unsigned NOT NULL DEFAULT '0', `S_CITYNAME` varchar(30) NOT NULL, `N_PROVID` int(10) unsigned NOT NULL, `S_STATE` varchar(1) DEFAULT NULL COMMENT '0 - 禁用\r\n1 - 启用 \r\n', PRIMARY KEY (`N_CITYID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of dict_city -- ---------------------------- INSERT INTO `dict_city` VALUES ('600', '美国', '1', '1'); INSERT INTO `dict_city` VALUES ('601', '日本', '1', '1'); INSERT INTO `dict_city` VALUES ('602', '英国', '1', '1'); INSERT INTO `dict_city` VALUES ('603', '法国', '1', '1'); INSERT INTO `dict_city` VALUES ('604', '德国', '1', '1'); INSERT INTO `dict_city` VALUES ('605', '加拿大', '1', '1'); INSERT INTO `dict_city` VALUES ('606', '澳大利亚', '1', '1'); INSERT INTO `dict_city` VALUES ('607', '俄罗斯', '1', '1'); INSERT INTO `dict_city` VALUES ('608', '新西兰', '1', '1'); INSERT INTO `dict_city` VALUES ('609', '意大利', '1', '1'); INSERT INTO `dict_city` VALUES ('610', '韩国', '1', '1'); INSERT INTO `dict_city` VALUES ('611', '比利时', '1', '1'); INSERT INTO `dict_city` VALUES ('612', '瑞士', '1', '1'); INSERT INTO `dict_city` VALUES ('613', '新加坡', '1', '1'); INSERT INTO `dict_city` VALUES ('614', '墨西哥', '1', '1'); INSERT INTO `dict_city` VALUES ('615', '荷兰', '1', '1'); INSERT INTO `dict_city` VALUES ('616', '巴西', '1', '1'); INSERT INTO `dict_city` VALUES ('617', '印度', '1', '1'); INSERT INTO `dict_city` VALUES ('618', '爱尔兰', '1', '1'); INSERT INTO `dict_city` VALUES ('619', '马来西亚', '1', '1'); INSERT INTO `dict_city` VALUES ('620', '丹麦', '1', '1'); INSERT INTO `dict_city` VALUES ('621', '南非', '1', '1'); INSERT INTO `dict_city` VALUES ('622', '西班牙', '1', '1'); INSERT INTO `dict_city` VALUES ('1000', '东城区', '10', '1'); INSERT INTO `dict_city` VALUES ('1001', '西城区', '10', '1'); INSERT INTO `dict_city` VALUES ('1002', '崇文区', '10', '1'); INSERT INTO `dict_city` VALUES ('1003', '宣武区', '10', '1'); INSERT INTO `dict_city` VALUES ('1004', '朝阳区 ', '10', '1'); INSERT INTO `dict_city` VALUES ('1005', '丰台区', '10', '1'); INSERT INTO `dict_city` VALUES ('1006', '石景山区', '10', '1'); INSERT INTO `dict_city` VALUES ('1007', '海淀区', '10', '1'); INSERT INTO `dict_city` VALUES ('1008', '门头沟区', '10', '1'); INSERT INTO `dict_city` VALUES ('1009', '房山区', '10', '1'); INSERT INTO `dict_city` VALUES ('1010', '通州区', '10', '1'); INSERT INTO `dict_city` VALUES ('1011', '顺义区 ', '10', '1'); INSERT INTO `dict_city` VALUES ('1012', '昌平区', '10', '1'); INSERT INTO `dict_city` VALUES ('1013', '大兴区', '10', '1'); INSERT INTO `dict_city` VALUES ('1014', '怀柔区', '10', '1'); INSERT INTO `dict_city` VALUES ('1015', '平谷区', '10', '1'); INSERT INTO `dict_city` VALUES ('1016', '密云县', '10', '1'); INSERT INTO `dict_city` VALUES ('1017', '延庆县', '10', '1'); INSERT INTO `dict_city` VALUES ('1018', '黄浦区 ', '11', '1'); INSERT INTO `dict_city` VALUES ('1019', '卢湾区', '11', '1'); INSERT INTO `dict_city` VALUES ('1020', '徐汇区', '11', '1'); INSERT INTO `dict_city` VALUES ('1021', '长宁区', '11', '1'); INSERT INTO `dict_city` VALUES ('1022', '静安区', '11', '1'); INSERT INTO `dict_city` VALUES ('1023', '普陀区', '11', '1'); INSERT INTO `dict_city` VALUES ('1024', '闸北区', '11', '1'); INSERT INTO `dict_city` VALUES ('1025', '虹口区 ', '11', '1'); INSERT INTO `dict_city` VALUES ('1026', '杨浦区', '11', '1'); INSERT INTO `dict_city` VALUES ('1027', '闵行区', '11', '1'); INSERT INTO `dict_city` VALUES ('1028', '宝山区', '11', '1'); INSERT INTO `dict_city` VALUES ('1029', '嘉定区', '11', '1'); INSERT INTO `dict_city` VALUES ('1030', '浦东新区', '11', '1'); INSERT INTO `dict_city` VALUES ('1031', '金山区', '11', '1'); INSERT INTO `dict_city` VALUES ('1032', '松江区 ', '11', '1'); INSERT INTO `dict_city` VALUES ('1033', '青浦区', '11', '1'); INSERT INTO `dict_city` VALUES ('1034', '南汇区', '11', '1'); INSERT INTO `dict_city` VALUES ('1035', '奉贤区', '11', '1'); INSERT INTO `dict_city` VALUES ('1036', '崇明县', '11', '1'); INSERT INTO `dict_city` VALUES ('1037', '和平区', '12', '1'); INSERT INTO `dict_city` VALUES ('1038', '河东区', '12', '1'); INSERT INTO `dict_city` VALUES ('1039', '河西区 ', '12', '1'); INSERT INTO `dict_city` VALUES ('1040', '南开区', '12', '1'); INSERT INTO `dict_city` VALUES ('1041', '河北区', '12', '1'); INSERT INTO `dict_city` VALUES ('1042', '红桥区', '12', '1'); INSERT INTO `dict_city` VALUES ('1043', '塘沽区', '12', '1'); INSERT INTO `dict_city` VALUES ('1044', '汉沽区', '12', '1'); INSERT INTO `dict_city` VALUES ('1045', '大港区', '12', '1'); INSERT INTO `dict_city` VALUES ('1046', '东丽区 ', '12', '1'); INSERT INTO `dict_city` VALUES ('1047', '西青区', '12', '1'); INSERT INTO `dict_city` VALUES ('1048', '津南区', '12', '1'); INSERT INTO `dict_city` VALUES ('1049', '北辰区', '12', '1'); INSERT INTO `dict_city` VALUES ('1050', '武清区', '12', '1'); INSERT INTO `dict_city` VALUES ('1051', '宝坻区', '12', '1'); INSERT INTO `dict_city` VALUES ('1052', '宁河县', '12', '1'); INSERT INTO `dict_city` VALUES ('1053', '静海县 ', '12', '1'); INSERT INTO `dict_city` VALUES ('1054', '蓟县', '12', '1'); INSERT INTO `dict_city` VALUES ('1055', '万州区', '13', '1'); INSERT INTO `dict_city` VALUES ('1056', '涪陵区', '13', '1'); INSERT INTO `dict_city` VALUES ('1057', '渝中区', '13', '1'); INSERT INTO `dict_city` VALUES ('1058', '大渡口区', '13', '1'); INSERT INTO `dict_city` VALUES ('1059', '江北区', '13', '1'); INSERT INTO `dict_city` VALUES ('1060', '沙坪坝区 ', '13', '1'); INSERT INTO `dict_city` VALUES ('1061', '九龙坡区', '13', '1'); INSERT INTO `dict_city` VALUES ('1062', '南岸区', '13', '1'); INSERT INTO `dict_city` VALUES ('1063', '北碚区', '13', '1'); INSERT INTO `dict_city` VALUES ('1064', '万盛区', '13', '1'); INSERT INTO `dict_city` VALUES ('1065', '双桥区', '13', '1'); INSERT INTO `dict_city` VALUES ('1066', '渝北区', '13', '1'); INSERT INTO `dict_city` VALUES ('1067', '巴南区 ', '13', '1'); INSERT INTO `dict_city` VALUES ('1068', '黔江区', '13', '1'); INSERT INTO `dict_city` VALUES ('1069', '长寿区', '13', '1'); INSERT INTO `dict_city` VALUES ('1070', '綦江县', '13', '1'); INSERT INTO `dict_city` VALUES ('1071', '潼南县', '13', '1'); INSERT INTO `dict_city` VALUES ('1072', '铜梁县', '13', '1'); INSERT INTO `dict_city` VALUES ('1073', '大足县', '13', '1'); INSERT INTO `dict_city` VALUES ('1074', '荣昌县 ', '13', '1'); INSERT INTO `dict_city` VALUES ('1075', '璧山县', '13', '1'); INSERT INTO `dict_city` VALUES ('1076', '梁平县', '13', '1'); INSERT INTO `dict_city` VALUES ('1077', '城口县', '13', '1'); INSERT INTO `dict_city` VALUES ('1078', '丰都县', '13', '1'); INSERT INTO `dict_city` VALUES ('1079', '垫江县', '13', '1'); INSERT INTO `dict_city` VALUES ('1080', '武隆县', '13', '1'); INSERT INTO `dict_city` VALUES ('1081', '忠县 ', '13', '1'); INSERT INTO `dict_city` VALUES ('1082', '开县', '13', '1'); INSERT INTO `dict_city` VALUES ('1083', '云阳县', '13', '1'); INSERT INTO `dict_city` VALUES ('1084', '奉节县', '13', '1'); INSERT INTO `dict_city` VALUES ('1085', '巫山�