data/config/city.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

INSERT INTO `sd_city` VALUES ('1', '北京', '0', '0', '0', 'beijing', '0', '1', '1', '', '', '');
INSERT INTO `sd_city` VALUES ('2', '天津', '0', '0', '0', 'tianjin', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('3', '河北', '0', '0', '0', 'hebei', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('4', '山西', '0', '0', '0', 'shanxi', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('5', '内蒙古', '0', '0', '0', 'neimenggu', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('6', '辽宁', '0', '0', '0', 'liaoning', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('7', '吉林', '0', '0', '0', 'jilin', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('8', '黑龙江', '0', '0', '0', 'heilongjiang', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('9', '上海', '0', '0', '0', 'shanghai', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('10', '江苏', '0', '0', '0', 'jiangsu', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('11', '浙江', '0', '0', '0', 'zhejiang', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('12', '安徽', '0', '0', '0', 'anhui', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('13', '福建', '0', '0', '0', 'fujian', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('14', '江西', '0', '0', '0', 'jiangxi', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('15', '山东', '0', '0', '0', 'shandong', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('16', '河南', '0', '0', '0', 'henan', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('17', '湖北', '0', '0', '0', 'hebeisheng', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('18', '湖南', '0', '0', '0', 'hunan', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('19', '广东', '0', '0', '0', 'guangdong', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('20', '广西', '0', '0', '0', 'guangxi', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('21', '海南', '0', '0', '0', 'hainan', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('22', '重庆', '0', '0', '0', 'chongqing', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('23', '四川', '0', '0', '0', 'sichuan', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('24', '贵州', '0', '0', '0', 'guizhou', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('25', '云南', '0', '0', '0', 'yunnan', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('26', '西藏', '0', '0', '0', 'xizang', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('27', '陕西', '0', '0', '0', 'shanxis', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('28', '甘肃', '0', '0', '0', 'gansu', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('29', '青海', '0', '0', '0', 'qinghai', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('30', '宁夏', '0', '0', '0', 'ningxia', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('31', '新疆', '0', '0', '0', 'xinjiang', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('32', '台湾', '0', '0', '0', 'taiwan', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('33', '香港', '0', '0', '0', 'xianggang', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('34', '澳门', '0', '0', '0', 'aomen', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('35', '东城区', '1', '0', '0', 'dongcheng', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('36', '西城区', '1', '0', '0', 'xicheng', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('37', '朝阳区', '1', '0', '0', 'chaoyang', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('38', '丰台区', '1', '0', '0', 'fengtai', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('39', '石景山区', '1', '0', '0', 'shijingshan', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('40', '海淀区', '1', '0', '0', 'haidian', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('41', '顺义区', '1', '0', '0', 'shunyi', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('42', '通州区', '1', '0', '0', 'tongzhou', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('43', '大兴区', '1', '0', '0', 'daxing', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('44', '房山区', '1', '0', '0', 'fangshan', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('45', '门头沟区', '1', '0', '0', 'mentougou', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('46', '昌平区', '1', '0', '0', 'changping', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('47', '平谷区', '1', '0', '0', 'pinggu', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('48', '密云区', '1', '0', '0', 'miyun', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('49', '怀柔区', '1', '0', '0', 'huairou', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('50', '延庆区', '1', '0', '0', 'yanqing', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('51', '和平区', '2', '0', '0', 'heping', '0', '1', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('52', '河东区', '2', '0', '0', 'hedong', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('53', '河西区', '2', '0', '0', 'hexi', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('54', '南开区', '2', '0', '0', 'nankai', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('55', '河北区', '2', '0', '0', 'hebeiqu', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('56', '红桥区', '2', '0', '0', 'hongqiao', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('57', '东丽区', '2', '0', '0', 'dongli', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('58', '西青区', '2', '0', '0', 'xiqing', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('59', '津南区', '2', '0', '0', 'jinnan', '0', '0', '0', '', '', '');
INSERT INTO `sd_city` VALUES ('60', '北辰区', '2', '0', '0', 'beicheng', '0', '0', '0', '', '', '');