全国各城市的代码邮编sql（mysql版）CREATE TABLE `city` (
`city_id` int(10) NOT NULL,
`city_name` varchar(50) NOT NULL,
`province_id` varchar(20) NOT NULL,
`first_letter` varchar(20) DEFAULT NULL,
`is_hot` int(10) NOT NULL DEFAULT '0',
`state` int(10) NOT NULL DEFAULT '1',
PRIMARY KEY (`city_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
CREATE TABLE `province` (
`province_id` varchar(20) NOT NULL,
`province_name` varchar(50) NOT NULL,
PRIMARY KEY (`province_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
CREATE TABLE `region` (
`region_id` int(10) NOT NULL,
`region_name` varchar(50) NOT NULL COMMENT '地区名称',
`city_id` int(10) NOT NULL DEFAULT '0' COMMENT '⽗地区ID',
PRIMARY KEY (`region_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
CREATE TABLE `zipcode` (
`zip_id` int(11) NOT NULL AUTO_INCREMENT,
`region_id` varchar(20) NOT NULL,
`zip_number` varchar(20) NOT NULL,
`code` varchar(20) NOT NULL,
PRIMARY KEY (`zip_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3145 DEFAULT CHARSET=gbk;
/*
Navicat MySQL Data Transfer
Source Server : MySQL
Source Server Version : 50137
Source Host : localhost:3306
Source Database : indoorlocation
Target Server Type : MYSQL
Target Server Version : 50137
File Encoding : 65001
Date: 2015-03-01 23:15:36
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
`city_id` int(10) NOT NULL,
`city_name` varchar(50) NOT NULL,
`province_id` varchar(20) NOT NULL,
`first_letter` varchar(20) DEFAULT NULL,
`is_hot` int(10) NOT NULL DEFAULT '0',
`state` int(10) NOT NULL DEFAULT '1',
PRIMARY KEY (`city_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of city
-- ----------------------------
INSERT INTO `city` VALUES ('110100', '北京(市辖区)', '110000', 'bj', '0', '1'); INSERT INTO `city` VALUES ('110200', '北京(县)', '110000', 'bj', '0', '1'); INSERT INTO `city` VALUES ('120100', '天津(市辖区)', '120000', 'tj', '0', '1'); INSERT INTO `city` VALUES ('120200', '天津(县)', '120000', 'tj', '0', '1'); INSERT INTO `city` VALUES ('130100', '⽯家庄市', '130000', 'sjz', '0', '1'); INSERT INTO `city` VALUES ('130200', '唐⼭市', '130000', 'ts', '0', '1'); INSERT INTO `city` VALUES ('130300', '秦皇岛市', '130000', 'qhd', '0', '1'); INSERT INTO `city` VALUES ('130400', '邯郸市', '130000', 'hd', '0', '1'); INSE
RT INTO `city` VALUES ('130500', '邢台市', '130000', 'xt', '0', '1'); INSERT INTO `city` VALUES ('130600', '保定市', '130000', 'bd', '0', '1'); INSERT INTO `city` VALUES ('130700', '张家⼝市', '130000', 'zjk', '0', '1'); INSERT INTO `city` VALUES ('130800', '承德市', '130000', 'cd', '0', '1'); INSERT INTO `city` VALUES ('130900', '沧州市', '130000', 'cz', '0', '1'); INSERT INTO `city` VALUES ('131000', '廊坊市', '130000', 'lf', '0', '1'); INSERT INTO `city` VALUES ('131100', '衡⽔市', '130000', 'hs', '0', '1'); INSERT INTO `city` VALUES ('140100', '太原市', '140000', 'ty', '0', '1'); INSERT INTO `city` VALUES ('140200', '⼤同市', '140000', 'dt', '0', '1'); INSERT INTO `city` VALUES ('140300', '阳泉市', '140000', 'yq', '0', '1'); INSERT INTO `city` VALUES ('140400', '长治市', '140000', 'cz', '0', '1'); INSERT INTO `city` VALUES ('140500', '晋城市', '140000', 'zc', '0', '1'); INSERT INTO `city` VALUES ('140600', '朔州市', '140000', 'sz', '0', '1'); INSERT INTO `city` VALUES ('140700', '晋中市', '140000', 'jz', '0', '1'); INSERT INTO `city` VALUES ('140800', '运城市', '140000', 'yc', '0', '1'); INSERT INTO `city` VALUES ('140900', '忻州市', '140000', 'xz', '0', '1'); INSERT INTO `city` VALUES ('141000', '临汾市', '140000', 'll', '0', '1'); INSERT INTO `city` VALUES ('141100', '吕梁市', '140000', 'll', '0', '1'); INSERT INTO `city` VALUES ('150100', '呼和浩特市', '150000', 'hh', '0', '1'); INSERT INTO `city` VALUES ('150200', '包头市', '150000', 'bt', '0', '1'); INSERT INTO `city` VALUES ('150300', '乌海市', '150000', 'wh', '0', '1'); INSERT INTO `city` VALUES ('150400', '⾚峰市', '150000', 'cf', '0', '1'); INSERT INTO `city` VALUES ('150500', '通辽市', '150000', 'tl', '0', '1'); INSERT INTO `city` VALUES ('150600',
'鄂尔多斯市', '150000', 'ee', '0', '1'); INSERT INTO `city` VALUES ('150700', '呼伦贝尔市', '150000', 'hl', '0', '1'); INSERT INTO `city` VALUES ('150800', '巴彦淖尔市', '150000', 'by', '0', '1'); INSERT INTO `city` VALUES ('150900', '乌兰察布市', '150000', 'wl', '0', '1'); INSERT INTO `city` VALUES ('152200', '兴安盟', '150000', 'xa', '0', '1'); INSERT INTO `city` VALUES ('152500', '锡林郭勒盟', '150000', 'xl', '0', '1'); INSERT INTO `city` VALUES ('152900', '阿拉善盟', '150000', 'al', '0', '1'); INSERT INTO `city` VALUES ('210100', '沈阳市', '210000', 'sy', '1', '1'); INSERT INTO `city` VALUES ('210200', '⼤连市', '210000', 'dl', '1', '1'); INSERT INTO `city` VALUES ('210300', '鞍⼭市', '210000', 'as', '0', '1'); INSERT INTO `city` VALUES ('210400', '抚顺市', '210000', 'fs', '0', '1'); INSERT INTO `city` VALUES ('210500', '本溪市', '210000', 'bx', '0', '1'); INSERT INTO `city` VALUES ('210600', '丹东市', '210000', 'dd', '0', '1'); INSERT INTO `city` VALUES ('210700', '锦州市', '210000', 'jz', '0', '1'); INSERT INTO `city` VALUES ('210800', '营⼝市', '210000', 'yk', '0', '1'); INSERT INTO `city` VALUES ('210900', '⾩新市', '210000', 'fx', '0', '1'); INSERT INTO `city` VALUES ('211000', '辽阳市', '210000', 'ly', '0', '1'); INSERT INTO `city` VALUES ('211100', '盘锦市', '210000', 'pj', '0', '1'); INSERT INTO `city` VALUES ('211200', '铁岭市', '210000', 'tl', '0', '1'); INSERT INTO `city` VALUES ('211300', '朝阳市', '210000', 'cy', '0', '1'); INSERT INTO `city` VALUES ('211400', '葫芦岛市', '210000', 'hld', '0', '1'); INSERT INTO `city` VALUES ('220100', '长春市', '220000', 'cc', '0', '1'); INSERT INTO `city` VALUES ('220200', '吉林市', '220000', 'jl', '0', '1'); INSERT INTO `city` VALUES ('220300', '四平市', '220000', 'sp', '0', '1');
INSERT INTO `city` VALUES ('222400', '延边朝鲜族⾃治州', '220000', 'yb', '0', '1'); INSERT INTO `city` VALUES ('230100', '哈尔滨市', '230000', 'heb', '0', '1'); INSERT INTO `city` VALUES ('230200', '齐齐哈尔市', '230000', 'qq', '0', '1'); INSERT INTO `city` VALUES ('230300', '鸡西市', '230000', 'jx', '0', '1');
INSERT INTO `city` VALUES ('230400', '鹤岗市', '230000', 'hg', '0', '1'); INSERT INTO `city` VALUES ('230500', '双鸭⼭市', '230000', 'sy', '0', '1'); INSERT INTO `city` VALUES ('230600', '⼤庆市', '230000', 'dq', '0', '1'); INSERT INTO `city` VALUES ('230700', '伊春市', '230000', 'yc', '0', '1'); INSERT INTO `city` VALUES ('230800', '佳⽊斯市', '230000', 'jms', '0', '1'); INSERT INTO `city` VALUES ('230900', '七台河市', '230000', 'qth', '0', '1'); INSERT INTO `city` VALUES ('231000', '牡丹江市', '230000', 'mdj', '0', '1'); INSERT INTO `city` VALUES ('231100', '⿊河市', '230000', 'hh', '0', '1'); INSERT INTO `city` VALUES ('231200', '绥化市', '230000', 'sh', '0', '1'); INSERT INTO `city` VALUES ('232700', '⼤兴安岭地区', '230000', 'dxal', '0', '1'); INSERT INTO `city` VALUES ('310100', '上海(市辖区)', '310000', 'sh', '0', '1'); INSERT INTO `city` VALUES ('310200', '上海(县)', '310000', 'sh', '0', '1'); INSERT INTO `city` VALUES ('320100', '南京市', '320000', 'nj', '0', '1');
INSERT INTO `city` VALUES ('320200', '⽆锡市', '320000', 'wx', '0', '1'); INSERT INTO `city` VALUES ('320300', '徐州市', '320000', 'xz', '0', '1'); INSERT INTO `city` VALUES ('320400', '常州市', '320000', '
cz', '0', '1'); INSERT INTO `city` VALUES ('320500', '苏州市', '320000', 'sz', '0', '1'); INSERT INTO `city` VALUES ('320600', '南通市', '320000', 'nt', '0', '1');
INSERT INTO `city` VALUES ('320700', '连云港市', '320000', 'lyg', '0', '1'); INSERT INTO `city` VALUES ('320800', '淮安市', '320000', 'ha', '0', '1'); INSERT INTO `city` VALUES ('320900', '盐城市', '320000', 'yc', '0', '1'); INSERT INTO `city` VALUES ('321000', '扬州市', '320000', 'yz', '0', '1'); INSERT INTO `city` VALUES ('321100', '镇江市', '320000', 'zj', '0', '1');
INSERT INTO `city` VALUES ('321200', '泰州市', '320000', 'tz', '0', '1');
INSERT INTO `city` VALUES ('321300', '宿迁市', '320000', 'sq', '0', '1'); INSERT INTO `city` VALUES ('330100', '杭州市', '330000', 'hz', '0', '1'); INSERT INTO `city` VALUES ('330200', '宁波市', '330000', 'nb', '0', '1'); INSERT INTO `city` VALUES ('330300', '温州市', '330000', 'wz', '0', '1'); INSERT INTO `city` VALUES ('330400', '嘉兴市', '330000', 'jx', '0', '1');
INSERT INTO `city` VALUES ('330500', '湖州市', '330000', 'hz', '0', '1'); INSERT INTO `city` VALUES ('330600', '绍兴市', '330000', 'sx', '0', '1'); INSERT INTO `city` VALUES ('330700', '⾦华市', '330000', 'jh', '0', '1');
INSERT INTO `city` VALUES ('330800', '衢州市', '330000', 'hz', '0', '1'); INSERT INTO `city` VALUES ('330900', '⾈⼭市', '330000', 'zs', '0', '1'); INSERT INTO `city` VALUES ('331000', '台州市', '330000', 'tz', '0', '1');
INSERT INTO `city` VALUES ('331100', '丽⽔市', '330000', 'ls', '0', '1');
INSERT INTO `city` VALUES ('340100', '合肥市', '340000', 'hf', '0', '1');
INSERT INTO `city` VALUES ('340200', '芜湖市', '340000', 'wh', '0', '1'); INSERT INTO `city` VALUES ('340300', '蚌埠市', '340000', 'bb', '0', '1'); INSERT INTO `city` VALUES ('340400', '淮南市', '340000', 'hn', '0', '1'); INSERT INTO `city` VALUES ('340500', '马鞍⼭市', '340000', 'mas', '0', '1'); INSERT INTO `city` VALUES ('340600', '淮北市', '340000', 'hb', '0', '1'); INSERT INTO `city` VALUES ('340700', '铜陵市', '340000', 'tl', '0', '1');
INSERT INTO `city` VALUES ('340800', '安庆市', '340000', 'aq', '0', '1'); INSERT INTO `city` VALUES ('341000', '黄⼭市', '340000', 'hs', '0', '1'); INSERT INTO `city` VALUES ('341100', '滁州市', '340000', 'cz', '0', '1'); INSERT INTO `city` VALUES ('341200', '⾩阳市', '340000', 'fy', '0', '1');
INSERT INTO `city` VALUES ('341300', '宿州市', '340000', 'sz', '0', '1'); INSERT INTO `city` VALUES
('341400', '巢湖市', '340000', 'ch', '0', '1'); INSERT INTO `city` VALUES ('341500', '六安市', '340000', 'la', '0', '1');
INSERT INTO `city` VALUES ('341600', '亳州市', '340000', 'hz', '0', '1'); INSERT INTO `city` VALUES ('341700', '池州市', '340000', 'cz', '0', '1'); INSERT INTO `city` VALUES ('341800', '宣城市', '340000', 'xc', '0', '1'); INSERT INTO `city` VALUES ('350100', '福州市', '350000', 'fz', '0', '1');
INSERT INTO `city` VALUES ('350200', '厦门市', '350000', 'xm', '0', '1'); INSERT INTO `city` VALUES ('350300', '莆⽥市', '350000', 'ft', '0', '1');
INSERT INTO `city` VALUES ('350400', '三明市', '350000', 'sm', '0', '1'); INSERT INTO `city` VALUES ('350500', '泉州市', '350000', 'qz', '0', '1'); INSERT INTO `city` VALUES ('350600', '漳州市', '350000', 'zz', '0', '1'); INSERT INTO `city` VALUES ('350700', '南平市', '350000', 'np', '0', '1'); INSERT INTO `city` VALUES ('350800', '龙岩市', '350000', 'ly', '0', '1');
INSERT INTO `city` VALUES ('350900', '宁德市', '350000', 'nd', '0', '1');
INSERT INTO `city` VALUES ('360900', '宜春市', '360000', 'yc', '0', '1');
INSERT INTO `city` VALUES ('361000', '抚州市', '360000', 'fz', '0', '1');
INSERT INTO `city` VALUES ('361100', '上饶市', '360000', 'sx', '0', '1');
INSERT INTO `city` VALUES ('370100', '济南市', '370000', 'jn', '0', '1');
INSERT INTO `city` VALUES ('370200', '青岛市', '370000', 'qd', '0', '1');
INSERT INTO `city` VALUES ('370300', '淄博市', '370000', 'zb', '0', '1');
INSERT INTO `city` VALUES ('370400', '枣庄市', '370000', 'zz', '0', '1');
INSERT INTO `city` VALUES ('370500', '东营市', '370000', 'dy', '0', '1');
INSERT INTO `city` VALUES ('370600', '烟台市', '370000', 'yt', '0', '1');
INSERT INTO `city` VALUES ('370700', '潍坊市', '370000', 'lf', '0', '1');
INSERT INTO `city` VALUES ('370800', '济宁市', '370000', 'jn', '0', '1');
INSERT INTO `city` VALUES ('370900', '泰安市', '370000', 'ta', '0', '1');
INSERT INTO `city` VALUES ('371000', '威海市', '370000', 'wh', '0', '1');
INSERT INTO `city` VALUES ('371100', '⽇照市', '370000', 'rz', '0', '1');
INSERT INTO `city` VALUES ('371200', '莱芜市', '370000', 'lw', '0', '1');
INSERT INTO `city` VALUES ('371300', '临沂市', '370000', 'ly', '0', '1');
INSERT INTO `city` VALUES ('371400', '德州市', '370000', 'dz', '0', '1');
INSERT INTO `city` VALUES ('371500', '聊城市', '370000', 'lc', '0', '1');
INSERT INTO `city` VALUES ('371600', '滨州市', '370000', 'bz', '0', '1');
INSERT INTO `city` VALUES ('371700', '荷泽市', '370000', 'hz', '0', '1');
INSERT INTO `city` VALUES ('410100', '郑州市', '410000', 'zz', '0', '1');
INSERT INTO `city` VALUES ('410200', '开封市', '410000', 'kf', '0', '1');
INSERT INTO `city` VALUES ('410300', '洛阳市', '410000', 'ly', '0', '1');
顺丰速运快递单查询INSERT INTO `city` VALUES ('410400', '平顶⼭市', '410000', 'pds', '0', '1');
mpv排名INSERT INTO `city` VALUES ('410500', '安阳市', '410000', 'ay', '0', '1');
INSERT INTO `city` VALUES ('410600', '鹤壁市', '410000', 'hb', '0', '1');
INSERT INTO `city` VALUES ('410700', '新乡市', '410000', 'xx', '0', '1');
INSERT INTO `city` VALUES ('410800', '焦作市', '410000', 'jz', '0', '1');
INSERT INTO `city` VALUES ('410900', '濮阳市', '410000', 'py', '0', '1');
INSERT INTO `city` VALUES ('411000', '许昌市', '410000', 'xc', '0', '1');
INSERT INTO `city` VALUES ('411100', '漯河市', '410000', 'lh', '0', '1');
INSERT INTO `city` VALUES ('411200', '三门峡市', '410000', 'smx', '0', '1');
INSERT INTO `city` VALUES ('411300', '南阳市', '410000', 'ny', '0', '1');
INSERT INTO `city` VALUES ('411400', '商丘市', '410000', 'sq', '0', '1');
INSERT INTO `city` VALUES ('411500', '信阳市', '410000', 'xy', '0', '1');
INSERT INTO `city` VALUES ('411600', '周⼝市', '410000', 'zk', '0', '1');
INSERT INTO `city` VALUES ('411700', '驻马店市', '410000', 'zmd', '0', '1');
INSERT INTO `city` VALUES ('420100', '武汉市', '420000', 'wh', '0', '1');
INSERT INTO `city` VALUES ('420200', '黄⽯市', '420000', 'hs', '0', '1');
INSERT INTO `city` VALUES ('420300', '⼗堰市', '420000', 'sy', '0', '1');
INSERT INTO `city` VALUES ('420500', '宜昌市', '420000', 'yc', '0', '1');
INSERT INTO `city` VALUES ('420600', '襄樊市', '420000', 'xf', '0', '1');
INSERT INTO `city` VALUES ('420700', '鄂州市', '420000', 'ez', '0', '1');
INSERT INTO `city` VALUES ('420800', '荆门市', '420000', 'xm', '0', '1');
INSERT INTO `city` VALUES ('420900', '孝感市', '420000', 'xg', '0', '1');
INSERT INTO `city` VALUES ('421000', '荆州市', '420000', 'zj', '0', '1');
INSERT INTO `city` VALUES ('421100', '黄冈市', '420000', 'hg', '0', '1');
INSERT INTO `city` VALUES ('421200', '咸宁市', '420000', 'xn', '0', '1');
INSERT INTO `city` VALUES ('421300', '随州市', '420000', 'sz', '0', '1');
INSERT INTO `city` VALUES ('422800', '恩施⼟家族苗族⾃治州', '420000', 'es', '0', '1'); INSERT INTO `city` VALUES ('429000', '省直辖⾏政单位', '420000', 'sz', '0', '1'); INSERT INTO `city` VALUES ('430100', '长沙市', '430000', 'cs', '0', '1');
INSERT INTO `city` VALUES ('430200', '株洲市', '430000', 'zz', '0', '1');
INSERT INTO `city` VALUES ('430300', '湘潭市', '430000', 'xt', '0', '1');
INSERT INTO `city` VALUES ('430400', '衡阳市', '430000', 'hy', '0', '1');
INSERT INTO `city` VALUES ('430500', '邵阳市', '430000', 'sy', '0', '1');
INSERT INTO `city` VALUES ('430600', '岳阳市', '430000', 'yy', '0', '1');
也许有一天我老无所依INSERT INTO `city` VALUES ('430700', '常德市', '430000', 'cd', '0', '1');
INSERT INTO `city` VALUES ('430800', '张家界市', '430000', 'zjj', '0', '1');
INSERT INTO `city` VALUES ('430900', '益阳市', '430000', 'yy', '0', '1');
INSERT INTO `city` VALUES ('431000', '郴州市', '430000', 'cz', '0', '1');
INSERT INTO `city` VALUES ('431100', '永州市', '430000', 'yz', '0', '1');
INSERT INTO `city` VALUES ('431200', '怀化市', '430000', 'hh', '0', '1');
INSERT INTO `city` VALUES ('440700', '江门市', '440000', 'jm', '0', '1');
INSERT INTO `city` VALUES ('440800', '湛江市', '440000', 'zj', '0', '1');
INSERT INTO `city` VALUES ('440900', '茂名市', '440000', 'mm', '0', '1');
INSERT INTO `city` VALUES ('441200', '肇庆市', '440000', 'zq', '0', '1');
INSERT INTO `city` VALUES ('441300', '惠州市', '440000', 'hz', '0', '1');
INSERT INTO `city` VALUES ('441400', '梅州市', '440000', 'mz', '0', '1');
INSERT INTO `city` VALUES ('441500', '汕尾市', '440000', 'sw', '0', '1');
INSERT INTO `city` VALUES ('441600', '河源市', '440000', 'hy', '0', '1');
INSERT INTO `city` VALUES ('441700', '阳江市', '440000', 'yj', '0', '1');
INSERT INTO `city` VALUES ('441800', '清远市', '440000', 'qy', '0', '1');苏州大学好专业
INSERT INTO `city` VALUES ('441900', '东莞市', '440000', 'dw', '0', '1');
INSERT INTO `city` VALUES ('442000', '中⼭市', '440000', 'zs', '0', '1');
INSERT INTO `city` VALUES ('445100', '潮州市', '440000', 'cz', '0', '1');
INSERT INTO `city` VALUES ('445200', '揭阳市', '440000', 'jy', '0', '1');
INSERT INTO `city` VALUES ('445300', '云浮市', '440000', 'yf', '0', '1');
INSERT INTO `city` VALUES ('450100', '南宁市', '450000', 'nn', '0', '1');
INSERT INTO `city` VALUES ('450200', '柳州市', '450000', 'lz', '0', '1');
INSERT INTO `city` VALUES ('450300', '桂林市', '450000', 'gl', '0', '1');
INSERT INTO `city` VALUES ('450400', '梧州市', '450000', 'wz', '0', '1');
INSERT INTO `city` VALUES ('450500', '北海市', '450000', 'bh', '0', '1');
INSERT INTO `city` VALUES ('450600', '防城港市', '450000', 'fc', '0', '1');
INSERT INTO `city` VALUES ('450700', '钦州市', '450000', 'rz', '0', '1');
INSERT INTO `city` VALUES ('450800', '贵港市', '450000', 'gg', '0', '1');
INSERT INTO `city` VALUES ('450900', '⽟林市', '450000', 'yl', '0', '1');
INSERT INTO `city` VALUES ('451000', '百⾊市', '450000', 'bs', '0', '1');
INSERT INTO `city` VALUES ('451100', '贺州市', '450000', 'hz', '0', '1');
INSERT INTO `city` VALUES ('451200', '河池市', '450000', 'hc', '0', '1');
INSERT INTO `city` VALUES ('451300', '来宾市', '450000', 'lb', '0', '1');
INSERT INTO `city` VALUES ('451400', '崇左市', '450000', 'cz', '0', '1');
INSERT INTO `city` VALUES ('460100', '海⼝市', '460000', 'hk', '0', '1');
INSERT INTO `city` VALUES ('460200', '三亚市', '460000', 'sy', '0', '1');
积分在哪里看INSERT INTO `city` VALUES ('469000', '省直辖县级⾏政单位', '460000', 'sz', '0', '1'); INSERT INTO `city` VALUES ('500100', '重庆(市辖区)', '500000', 'cq', '0', '1'); INSERT INTO `city` VALUES ('500200', '重庆(县)', '500000', 'cq', '0', '1');
INSERT INTO `city` VALUES ('500300', '重庆(市)', '500000', 'cq', '0', '1');
INSERT INTO `city` VALUES ('510100', '成都市', '510000', 'cd', '0', '1');
INSERT INTO `city` VALUES ('510300', '⾃贡市', '510000', 'zg', '0', '1');
INSERT INTO `city` VALUES ('510400', '攀枝花市', '510000', 'pzh', '0', '1');
INSERT INTO `city` VALUES ('510500', '泸州市', '510000', 'lz', '0', '1');
INSERT INTO `city` VALUES ('510600', '德阳市', '510000', 'dy', '0', '1');
INSERT INTO `city` VALUES ('510700', '绵阳市', '510000', 'jy', '0', '1');
INSERT INTO `city` VALUES ('510800', '⼴元市', '510000', 'gy', '0', '1');
INSERT INTO `city` VALUES ('510900', '遂宁市', '510000', 'sn', '0', '1');
INSERT INTO `city` VALUES ('511000', '内江市', '510000', 'nj', '0', '1');
INSERT INTO `city` VALUES ('511100', '乐⼭市', '510000', 'ls', '0', '1');
INSERT INTO `city` VALUES ('511300', '南充市', '510000', 'nc', '0', '1');
INSERT INTO `city` VALUES ('511400', '眉⼭市', '510000', 'ms', '0', '1');
INSERT INTO `city` VALUES ('511500', '宜宾市', '510000', 'yb', '0', '1');
INSERT INTO `city` VALUES ('511600', '⼴安市', '510000', 'ga', '0', '1');
INSERT INTO `city` VALUES ('511700', '达州市', '510000', 'dz', '0', '1');
INSERT INTO `city` VALUES ('511800', '雅安市', '510000', 'ya', '0', '1');
INSERT INTO `city` VALUES ('511900', '巴中市', '510000', 'bz', '0', '1');
INSERT INTO `city` VALUES ('512000', '资阳市', '510000', 'zy', '0', '1');
INSERT INTO `city` VALUES ('513200', '阿坝藏族羌族⾃治州', '510000', 'ab', '0', '1'); INSERT INTO `city` VALUES ('513300', '⽢孜藏族⾃治州', '510000', 'gm', '0', '1'); INSERT INTO `city` VALUES ('513400', '凉⼭彝族⾃治州', '510000', 'ls', '0', '1'); INSERT INTO `city` VALUES ('520100', '贵阳市', '520000', 'gy', '0', '1');
INSERT INTO `city` VALUES ('520200', '六盘⽔市', '520000', 'lp', '0', '1');
INSERT INTO `city` VALUES ('520300', '遵义市', '520000', 'zy', '0', '1');
INSERT INTO `city` VALUES ('520400', '安顺市', '520000', 'as', '0', '1');
LOL让人眼前一亮的IDINSERT INTO `city` VALUES ('522200', '铜仁地区', '520000', 'tr', '0', '1');
INSERT INTO `city` VALUES ('522300', '黔西南布依族苗族⾃治州', '520000', 'jx', '0', '1'); INSERT INTO `city` VALUES ('522400', '毕节地区', '520000', 'bj', '0', '1');
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。
发表评论