前面几篇讲的都是JSON格式的代码,本篇来列举MYSQL5中存放城市代码:
第一张表:省份表(province)
-- ----------------------------
-- Table structure for `province`
-- ----------------------------
DROP TABLE IF EXISTS `province`;
CREATE TABLE `province` (
`id` varchar(10) NOT NULL DEFAULT '',
`name` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
表中的数据:
-- ----------------------------
-- Records of province
-- ----------------------------
INSERT INTO `province` VALUES ('01', '北京');
INSERT INTO `province` VALUES ('02', '上海');
INSERT INTO `province` VALUES ('03', '天津');
INSERT INTO `province` VALUES ('04', '重庆');
INSERT INTO `province` VALUES ('05', '黑龙江');
INSERT INTO `province` VALUES ('06', '吉林');
INSERT INTO `province` VALUES ('07', '辽宁');
INSERT INTO `province` VALUES ('08', '内蒙古');
INSERT INTO `province` VALUES ('09', '河北');
INSERT INTO `province` VALUES ('10', '山西');
INSERT INTO `province` VALUES ('11', '陕西');
INSERT INTO `province` VALUES ('12', '山东');
INSERT INTO `province` VALUES ('13', '新疆');
INSERT INTO `province` VALUES ('14', '西藏');
INS