2015最新省市地区数据级联效果

/* Navicat MySQL Data Transfer Source Server : Mykalo Source Server Version : 50173 Source Database : MKL_DB Target Server Type : MYSQL Target Server Version : 50173 File Encoding : 65001 Date: 2015-04-30 19:13:37 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for tb_area -- ---------------------------- DROP TABLE IF EXISTS `tb_area`; CREATE TABLE `tb_area` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `area_no` int(11) unsigned DEFAULT NULL, `area_name` varchar(255) DEFAULT NULL, `parent_no` int(255) DEFAULT NULL, `area_code` varchar(255) DEFAULT NULL, `area_level` int(255) DEFAULT NULL, `type_name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3339 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tb_area -- ---------------------------- INSERT INTO `tb_area` VALUES ('1', '100000', '北京市', '0', '010', '1', '市'); INSERT INTO `tb_area` VALUES ('2', '100100', '延庆县', '100000', '010', '2', '区'); INSERT INTO `tb_area` VALUES ('3', '100200', '密云县', '100000', '010', '2', '区'); INSERT INTO `tb_area` VALUES ('4', '100300', '平谷区', '100000', '010', '2', '区'); INSERT INTO `tb_area` VALUES ('5', '100400', '怀柔区', '100000', '010', '2', '区'); INSERT INTO `tb_area` VALUES ('6', '100500', '大兴区', '100000', '010', '2', '区'); INSERT INTO `tb_area` VALUES ('7', '100600', '昌平区', '100000', '010', '2', '区'); INSERT INTO `tb_area` VALUES ('8', '100700', '顺义区', '100000', '010', '2', '区'); INSERT INTO `tb_area` VALUES ('9', '100800', '通州区', '100000', '010', '2', '区'); INSERT INTO `tb_area` VALUES ('10', '100900', '房山区', '100000', '010', '2', '区'); INSERT INTO `tb_area` VALUES ('11', '101000', '门头沟区', '100000', '010', '2', '区'); INSERT INTO `tb_area` VALUES ('12', '101100', '海淀区', '100000', '010', '2', '区'); INSERT INTO `tb_area` VALUES ('13', '101200', '石景山区', '100000', '010', '2', '区'); INSERT INTO `tb_area` VALUES ('14', '101300', '丰台区', '100000', '010', '2', '区'); INSERT INTO `tb_area` VALUES ('15', '101400', '朝阳区', '100000', '010', '2', '区'); INSERT INTO `tb_area` VALUES ('16', '101500', '西城区', '100000', '010', '2', '区'); INSERT INTO `tb_area` VALUES ('17', '101600', '东城区', '100000', '010', '2', '区'); INSERT INTO `tb_area` VALUES ('18', '110000', '上海市', '0', '021', '1', '市'); INSERT INTO `tb_area` VALUES ('19', '110100', '崇明县', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('20', '110200', '奉贤区', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('21', '110300', '青浦区', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('22', '110400', '松江区', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('23', '110500', '金山区', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('24', '110600', '浦东新区', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('25', '110700', '嘉定区', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('26', '110800', '宝山区', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('27', '110900', '闵行区', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('28', '111000', '杨浦区', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('29', '111100', '虹口区', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('30', '111200', '闸北区', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('31', '111300', '普陀区', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('32', '111400', '静安区', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('33', '111500', '长宁区', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('34', '111600', '徐汇区', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('35', '111700', '黄浦区', '110000', '021', '2', '区'); INSERT INTO `tb_area` VALUES ('36', '120000', '天津市', '0', '022', '1', '市'); INSERT INTO `tb_area` VALUES ('37', '120100', '蓟县', '120000', '022', '2', '区'); INSERT INTO `tb_area` VALUES ('38', '120200', '静海县', '120000', '022', '2', '区'); INSERT INTO `tb_area` VALUES ('39', '120300', '宁河县', '120000', '022', '2', '区'); INSERT INTO `tb_area` VALUES ('40', '120400', '滨海新区', '120000', '022', '2', '区'); INSERT INTO `tb_area` VALUES ('41', '120500', '宝坻区', '120000', '022', '2', '区'); INSERT INTO `tb_area` VALUES ('42', '120600', '武清区', '120000', '022', '2', '区'); INSERT INTO `tb_area` VALUES ('43', '120700', '北辰区', '120000', '022', '2', '区'); INSERT INTO `tb_area` VALUES ('44', '120800', '津南区', '120000', '022', '2', '区'); INSERT INTO `tb_area` VALUES ('45', '120900', '西青区', '120000', '022', '2', '区'); INSERT INTO `tb_area` VALUES ('46', '121000', '东丽区', '120000', '022', '2', '区'); INSERT INTO `tb_area` VALUES ('47', '121100', '红桥区', '120000', '022', '2', '区'); INSERT INTO `tb_area` VALUES ('48', '121200', '河北区', '120000', '022', '2', '区'); INSERT INTO `tb_area` VALUES ('49', '121300', '南开区', '120000', '022', '2', '区'); INSERT INTO `tb_area` VALUES ('50', '121400', '河西区', '120000', '022', '2', '区'); INSERT INTO `tb_area` VALUES ('51', '121500', '河东区', '120000', '022', '2', '区'); INSERT INTO `tb_area` VALUES ('52', '121600', '和平区', '120000', '022', '2', '区'); INSERT INTO `tb_area` VALUES ('53', '130000', '重庆市', '0', '0811', '1', '市'); INSERT INTO `tb_area` VALUES ('54', '130100', '彭水苗族土家族自治县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('55', '130200', '酉阳土家族苗族自治县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('56', '130300', '秀山土家族苗族自治县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('57', '130400', '石柱土家族自治县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('58', '130500', '巫溪县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('59', '130600', '巫山县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('60', '130700', '奉节县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('61', '130800', '云阳县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('62', '130900', '开县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('63', '131000', '忠县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('64', '131100', '武隆县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('65', '131200', '垫江县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('66', '131300', '丰都县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('67', '131400', '城口县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('68', '131500', '梁平县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('69', '131600', '璧山县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('70', '131700', '荣昌县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('71', '131800', '铜梁县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('72', '131900', '潼南县', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('73', '132000', '南川区', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('74', '132100', '永川区', '130000', '0814', '2', '区'); INSERT INTO `tb_area` VALUES ('75', '132200', '合川区', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('76', '132300', '江津区', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('77', '132400', '长寿区', '130000', '0811', '2', '区'); INSERT INTO `tb_area` VALUES ('78', '132500', '黔江区', '130000', '0811',