下載

https://download.csdn.net/download/fm15136/85028672

省

包含簡稱的

SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for province -- ---------------------------- DROP TABLE IF EXISTS `province`; CREATE TABLE `province` (`code` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省編碼',`name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省名',`SIMPLENAME` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '省的簡稱' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='省';-- ---------------------------- -- Records of province -- ---------------------------- INSERT INTO `province` VALUES ('110000', '北京市', '京'); INSERT INTO `province` VALUES ('120000', '天津市', '津'); INSERT INTO `province` VALUES ('130000', '河北省', '冀'); INSERT INTO `province` VALUES ('140000', '山西省', '晉'); INSERT INTO `province` VALUES ('150000', '內蒙古', '蒙'); INSERT INTO `province` VALUES ('210000', '遼寧省', '遼'); INSERT INTO `province` VALUES ('220000', '吉林省', '吉'); INSERT INTO `province` VALUES ('230000', '黑龍江', '黑'); INSERT INTO `province` VALUES ('310000', '上海市', '滬'); INSERT INTO `province` VALUES ('320000', '江蘇省', '蘇'); INSERT INTO `province` VALUES ('330000', '浙江省', '浙'); INSERT INTO `province` VALUES ('340000', '安徽省', '皖'); INSERT INTO `province` VALUES ('350000', '福建省', '閩'); INSERT INTO `province` VALUES ('360000', '江西省', '贛'); INSERT INTO `province` VALUES ('370000', '山東省', '魯'); INSERT INTO `province` VALUES ('410000', '河南省', '豫'); INSERT INTO `province` VALUES ('420000', '湖北省', '鄂'); INSERT INTO `province` VALUES ('430000', '湖南省', '湘'); INSERT INTO `province` VALUES ('440000', '廣東省', '粵'); INSERT INTO `province` VALUES ('450000', '廣 西', '桂'); INSERT INTO `province` VALUES ('460000', '海南省', '瓊'); INSERT INTO `province` VALUES ('500000', '重慶市', '渝'); INSERT INTO `province` VALUES ('510000', '四川省', '川'); INSERT INTO `province` VALUES ('520000', '貴州省', '貴'); INSERT INTO `province` VALUES ('530000', '云南省', '云'); INSERT INTO `province` VALUES ('540000', '西 藏', '藏'); INSERT INTO `province` VALUES ('610000', '陜西省', '陜'); INSERT INTO `province` VALUES ('620000', '甘肅省', '甘'); INSERT INTO `province` VALUES ('630000', '青海省', '青'); INSERT INTO `province` VALUES ('640000', '寧 夏', '寧'); INSERT INTO `province` VALUES ('650000', '新 疆', '新'); INSERT INTO `province` VALUES ('710000', '臺灣省', '臺'); INSERT INTO `province` VALUES ('810000', '香 港', '港'); INSERT INTO `province` VALUES ('820000', '澳 門', '澳'); SET FOREIGN_KEY_CHECKS=1;

沒有簡稱

SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for province -- ---------------------------- DROP TABLE IF EXISTS `province`; CREATE TABLE `province` (`code` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省編碼',`name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省名' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='省';-- ---------------------------- -- Records of province -- ---------------------------- INSERT INTO `province` VALUES ('110000', '北京市'); INSERT INTO `province` VALUES ('120000', '天津市'); INSERT INTO `province` VALUES ('130000', '河北省'); INSERT INTO `province` VALUES ('140000', '山西省'); INSERT INTO `province` VALUES ('150000', '內蒙古'); INSERT INTO `province` VALUES ('210000', '遼寧省'); INSERT INTO `province` VALUES ('220000', '吉林省'); INSERT INTO `province` VALUES ('230000', '黑龍江'); INSERT INTO `province` VALUES ('310000', '上海市'); INSERT INTO `province` VALUES ('320000', '江蘇省'); INSERT INTO `province` VALUES ('330000', '浙江省'); INSERT INTO `province` VALUES ('340000', '安徽省'); INSERT INTO `province` VALUES ('350000', '福建省'); INSERT INTO `province` VALUES ('360000', '江西省'); INSERT INTO `province` VALUES ('370000', '山東省'); INSERT INTO `province` VALUES ('410000', '河南省'); INSERT INTO `province` VALUES ('420000', '湖北省'); INSERT INTO `province` VALUES ('430000', '湖南省'); INSERT INTO `province` VALUES ('440000', '廣東省'); INSERT INTO `province` VALUES ('450000', '廣 西'); INSERT INTO `province` VALUES ('460000', '海南省'); INSERT INTO `province` VALUES ('500000', '重慶市'); INSERT INTO `province` VALUES ('510000', '四川省'); INSERT INTO `province` VALUES ('520000', '貴州省'); INSERT INTO `province` VALUES ('530000', '云南省'); INSERT INTO `province` VALUES ('540000', '西 藏'); INSERT INTO `province` VALUES ('610000', '陜西省'); INSERT INTO `province` VALUES ('620000', '甘肅省'); INSERT INTO `province` VALUES ('630000', '青海省'); INSERT INTO `province` VALUES ('640000', '寧 夏'); INSERT INTO `province` VALUES ('650000', '新 疆'); INSERT INTO `province` VALUES ('710000', '臺灣省'); INSERT INTO `province` VALUES ('810000', '香 港'); INSERT INTO `province` VALUES ('820000', '澳 門'); SET FOREIGN_KEY_CHECKS=1;

市

https://blog.csdn.net/fm15136/article/details/123706109

區

區太多無法保存

總結

以上是生活随笔為你收集整理的mysql -省市区（省）的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。