美国50个洲MySQL

/*
 Navicat Premium Data Transfer

 Source Server         : 美国超市
 Source Server Type    : MySQL
 Source Server Version : 50650 (5.6.50-log)
 Source Host           : 134.175.80.109:3306
 Source Schema         : mgcs_szzyqy_xyz

 Target Server Type    : MySQL
 Target Server Version : 50650 (5.6.50-log)
 File Encoding         : 65001

 Date: 16/04/2023 11:08:52
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for eb_continent
-- ----------------------------
DROP TABLE IF EXISTS `eb_continent`;
CREATE TABLE `eb_continent`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `chinses_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '中文名称',
  `english_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '英文全称',
  `nano` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '缩写',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '美国 各州表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of eb_continent
-- ----------------------------
INSERT INTO `eb_continent` VALUES (1, '阿拉巴马州', 'Alabama', 'AL');
INSERT INTO `eb_continent` VALUES (2, '阿拉斯加州', 'Alaska', 'AK');
INSERT INTO `eb_continent` VALUES (3, '亚利桑那洲', 'Arizona', 'AZ');
INSERT INTO `eb_continent` VALUES (4, '阿肯色州', 'Arkansas', 'AR');
INSERT INTO `eb_continent` VALUES (5, '加利福尼亚州', 'California', 'CA');
INSERT INTO `eb_continent` VALUES (6, '科罗拉多州', 'Colorado', 'CO');
INSERT INTO `eb_continent` VALUES (7, '康涅狄格州', 'Connecticut', 'CT');
INSERT INTO `eb_continent` VALUES (8, '特拉华州', 'Delaware', 'DE');
INSERT INTO `eb_continent` VALUES (9, '佛罗里达州', 'Florida', 'FL');
INSERT INTO `eb_continent` VALUES (10, '乔治亚州(佐治亚州)', 'Georgia', 'GA');
INSERT INTO `eb_continent` VALUES (11, '夏威夷州', 'Hawaii', 'HI');
INSERT INTO `eb_continent` VALUES (12, '爱达荷州', 'Idaho', 'ID');
INSERT INTO `eb_continent` VALUES (13, '伊利诺斯州', 'Illinois', 'IL');
INSERT INTO `eb_continent` VALUES (14, '印第安纳州', 'Indiana', 'IN');
INSERT INTO `eb_continent` VALUES (15, '爱荷华州', 'Iowa', 'IA');
INSERT INTO `eb_continent` VALUES (16, '堪萨斯州', 'Kansas', 'KS');
INSERT INTO `eb_continent` VALUES (17, '肯塔基州', 'Kentucky', 'KY');
INSERT INTO `eb_continent` VALUES (18, '路易斯安那州', 'Louisiana', 'LA');
INSERT INTO `eb_continent` VALUES (19, '缅因州', 'Maine', 'MD');
INSERT INTO `eb_continent` VALUES (20, '马萨诸塞州(麻省、麻州)', 'Massachusetts', 'MA');
INSERT INTO `eb_continent` VALUES (21, '密歇根州', 'Michigan', 'MI');
INSERT INTO `eb_continent` VALUES (22, '明尼苏达州', 'Minnesota', 'MN');
INSERT INTO `eb_continent` VALUES (23, '密西西比州', 'Mississippi', 'MS');
INSERT INTO `eb_continent` VALUES (24, '密苏里州', 'Missouri', 'MO');
INSERT INTO `eb_continent` VALUES (25, '蒙大拿州', 'Montana', 'MT');
INSERT INTO `eb_continent` VALUES (26, '内布拉斯加州', 'Nebraska', 'NE');
INSERT INTO `eb_continent` VALUES (27, '内华达州', 'Nevada', 'NV');
INSERT INTO `eb_continent` VALUES (28, '新罕布什尔州', 'New Hampshire', 'NH');
INSERT INTO `eb_continent` VALUES (29, '新泽西州', 'New Jersey', 'NJ');
INSERT INTO `eb_continent` VALUES (30, '新墨西哥州', 'New Mexico', 'NM');
INSERT INTO `eb_continent` VALUES (31, '纽约州', 'New York', 'NY');
INSERT INTO `eb_continent` VALUES (32, '北卡罗来纳州', 'North Carolina', 'NC');
INSERT INTO `eb_continent` VALUES (33, '北达科他州', 'North Dakota', 'ND');
INSERT INTO `eb_continent` VALUES (34, '俄亥俄州', 'Ohio', 'OH');
INSERT INTO `eb_continent` VALUES (35, '俄克拉荷马州', 'Oklahoma', 'OK');
INSERT INTO `eb_continent` VALUES (36, '俄勒冈州', 'Oregon', 'OR');
INSERT INTO `eb_continent` VALUES (37, '宾夕法尼亚州', 'Pennsylvania', 'PA');
INSERT INTO `eb_continent` VALUES (38, '罗德岛州', 'Rhode Island', 'RI');
INSERT INTO `eb_continent` VALUES (39, '南卡罗来纳州', 'South Carolina', 'SC');
INSERT INTO `eb_continent` VALUES (40, '南达科他州', 'South Dakota', 'SD');
INSERT INTO `eb_continent` VALUES (41, '田纳西州', 'Tennessee', 'TN');
INSERT INTO `eb_continent` VALUES (42, '得克萨斯州', 'Texas', 'TX');
INSERT INTO `eb_continent` VALUES (43, '犹他州', 'Utah', 'UT');
INSERT INTO `eb_continent` VALUES (44, '佛蒙特州', 'Vermont', 'VT');
INSERT INTO `eb_continent` VALUES (45, '弗吉尼亚州', 'Virginia', 'VA');
INSERT INTO `eb_continent` VALUES (46, '华盛顿州', 'Washington', 'WA');
INSERT INTO `eb_continent` VALUES (47, '西弗吉尼亚州', 'West Virginia', 'WV');
INSERT INTO `eb_continent` VALUES (48, '威斯康辛州(威斯康星州)', 'Wisconsin', 'WI');
INSERT INTO `eb_continent` VALUES (49, '怀俄明州', 'Wyoming', 'WY');
INSERT INTO `eb_continent` VALUES (50, '艾奥瓦州', 'Iowa', 'IA');

SET FOREIGN_KEY_CHECKS = 1;

手写了一个美国各州的MySQL表

如有错误请在评论区留言