全国各地车牌简称（数据库）

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50726 Source Host : localhost:3306 Source Database : datasets Target Server Type : MYSQL Target Server Version : 50726 File Encoding : 65001 Date: 2022-06-28 16:45:14 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for chepaihao -- ---------------------------- DROP TABLE IF EXISTS `chepaihao`; CREATE TABLE `chepaihao` ( `province` varchar(255) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `abbname` varchar(255) DEFAULT NULL, `prefix` varchar(255) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of chepaihao -- ---------------------------- INSERT INTO `chepaihao` VALUES ('北京市', '北京市', '京', '京A'); INSERT INTO `chepaihao` VALUES ('北京市', '北京市', '京', '京B'); INSERT INTO `chepaihao` VALUES ('北京市', '北京市', '京', '京C'); INSERT INTO `chepaihao` VALUES ('北京市', '北京市', '京', '京D'); INSERT INTO `chepaihao` VALUES ('北京市', '北京市', '京', '京E'); INSERT INTO `chepaihao` VALUES ('北京市', '北京市', '京', '京J'); INSERT INTO `chepaihao` VALUES ('北京市', '北京市', '京', '京K'); INSERT INTO `chepaihao` VALUES ('北京市', '北京市', '京', '京L'); INSERT INTO `chepaihao` VALUES ('北京市', '北京市', '京', '京M'); INSERT INTO `chepaihao` VALUES ('北京市', '北京市', '京', '京Y'); INSERT INTO `chepaihao` VALUES ('上海市', '上海市', '沪', '沪A'); INSERT INTO `chepaihao` VALUES ('上海市', '上海市', '沪', '沪B'); INSERT INTO `chepaihao` VALUES ('上海市', '上海市', '沪', '沪C'); INSERT INTO `chepaihao` VALUES ('上海市', '上海市', '沪', '沪D'); INSERT INTO `chepaihao` VALUES ('上海市', '崇明区', '沪', '沪R'); INSERT INTO `chepaihao` VALUES ('天津市', '天津市', '津', '津A'); INSERT INTO `chepaihao` VALUES ('天津市', '天津市', '津', '津B'); INSERT INTO `chepaihao` VALUES ('天津市', '天津市', '津', '津C'); INSERT INTO `chepaihao` VALUES ('天津市', '天津市', '津', '津D'); INSERT INTO `chepaihao` VALUES ('天津市', '天津市', '津', '津E'); INSERT INTO `chepaihao` VALUES ('重庆市', '重庆市', '渝', '渝A'); INSERT INTO `chepaihao` VALUES ('重庆市', '重庆市', '渝', '渝B'); INSERT INTO `chepaihao` VALUES ('重庆市', '永川区', '渝', '渝C'); INSERT INTO `chepaihao` VALUES ('重庆市', '万州区', '渝', '渝F'); INSERT INTO `chepaihao` VALUES ('重庆市', '涪陵区', '渝', '渝G'); INSERT INTO `chepaihao` VALUES ('重庆市', '黔江区', '渝', '渝H'); INSERT INTO `chepaihao` VALUES ('河北省', '石家庄市', '冀', '冀A'); INSERT INTO `chepaihao` VALUES ('河北省', '唐山市', '冀', '冀B'); INSERT INTO `chepaihao` VALUES ('河北省', '秦皇岛市', '冀', '冀C'); INSERT INTO `chepaihao` VALUES ('河北省', '邯郸市', '冀', '冀D'); INSERT INTO `chepaihao` VALUES ('河北省', '邢台市', '冀', '冀E'); INSERT INTO `chepaihao` VALUES ('河北省', '保定市', '冀', '冀F'); INSERT INTO `chepaihao` VALUES ('河北省', '张家口市', '冀', '冀G'); INSERT INTO `chepaihao` VALUES ('河北省', '承德市', '冀', '冀H'); INSERT INTO `chepaihao` VALUES ('河北省', '沧州市', '冀', '冀J'); INSERT INTO `chepaihao` VALUES ('河北省', '廊坊市', '冀', '冀R'); INSERT INTO `chepaihao` VALUES ('河北省', '沧州市', '冀', '冀S'); INSERT INTO `chepaihao` VALUES ('河北省', '衡水市', '冀', '冀T'); INSERT INTO `chepaihao` VALUES ('河南省', '郑州市', '豫', '豫A'); INSERT INTO `chepaihao` VALUES ('河南省', '开封市', '豫', '豫B'); INSERT INTO `chepaihao` VALUES ('河南省', '洛阳市', '豫', '豫C'); INSERT INTO `chepaihao` VALUES ('河南省', '平顶山市', '豫', '豫D'); INSERT INTO `chepaihao` VALUES ('河南省', '安阳市', '豫', '豫E'); INSERT INTO `chepaihao` VALUES ('河南省', '鹤壁市', '豫', '豫F'); INSERT INTO `chepaihao` VALUES ('河南省', '新乡市', '豫', '豫G'); INSERT INTO `chepaihao` VALUES ('河南省', '焦作市', '豫', '豫H'); INSERT INTO `chepaihao` VALUES ('河南省', '濮阳市', '豫', '豫J'); INSERT INTO `chepaihao` VALUES ('河南省', '许昌市', '豫', '豫K'); INSERT INTO `chepaihao` VALUES ('河南省', '漯河市', '豫', '豫L'); INSERT INTO `chepaihao` VALUES ('河南省', '三门峡市', '豫', '豫M'); INSERT INTO `chepaihao` VALUES ('河南省', '商丘市', '豫', '豫N'); INSERT INTO `chepaihao` VALUES ('河南省', '周口市', '豫', '豫P'); INSERT INTO `chepaihao` VALUES ('河南省', '驻马店市', '豫', '豫Q'); INSERT INTO `chepaihao` VALUES ('河南省', '南阳市', '豫', '豫R'); INSERT INTO `chepaihao` VALUES ('河南省', '信阳市', '豫', '豫S'); INSERT INTO `chepaihao` VALUES ('河南省', '济源市', '豫', '豫U'); INSERT INTO `chepaihao` VALUES ('云南省', '昆明市', '云', '云A'); INSERT INTO `chepaihao` VALUES ('云南省', '东川区', '云', '云A-V'); INSERT INTO `chepaihao` VALUES ('云南省', '昭通市', '云', '云C'); INSERT INTO `chepaihao` VALUES ('云南省', '曲靖市', '云', '云D'); INSERT INTO `chepaihao` VALUES ('云南省', '楚雄彝族自治州', '云', '云E'); INSERT INTO `chepaihao` VALUES ('云南省', '玉溪市', '云', '云F'); INSERT INTO `chepaihao` VALUES ('云南省', '红河哈尼族彝族自治州', '云', '云G'); INSERT INTO `chepaihao` VALUES ('云南省', '文山壮族苗族自治州', '云', '云H'); INSERT INTO `chepaihao` VALUES ('云南省', '思茅区', '云', '云J'); INSERT INTO `chepaihao` VALUES ('云南省', '西双版纳傣族自治州', '云', '云K'); INSERT INTO `chepaihao` VALUES ('云南省', '大理白族自治州', '云', '云L'); INSERT INTO `chepaihao` VALUES ('云南省', '保山市', '云', '云M'); INSERT INTO `chepaihao` VALUES ('云南省', '德宏傣族景颇族自治州', '云', '云N'); INSERT INTO `chepaihao` VALUES ('云南省', '丽江市', '云', '云P'); INSERT INTO `chepaihao` VALUES ('云南省', '怒江傈僳族自治州', '云', '云Q'); INSERT INTO `chepaihao` VALUES ('云南省', '迪庆藏族自治州', '云', '云R'); INSERT INTO `chepaihao` VALUES ('云南省', '临沧市', '云', '云S'); INSERT INTO `chepaihao` VALUES ('辽宁省', '沈阳市', '辽', '辽A'); INSERT INTO `chepaihao` VALUES ('辽宁省', '大连市', '辽', '辽B'); INSERT INTO `chepaihao` VALUES ('辽宁省', '鞍山市', '辽', '辽C'); INSERT INTO `chepaihao` VALUES ('辽宁省', '抚顺市', '辽', '辽D'); INSERT INTO `chepaihao` VALUES ('辽宁省', '本溪市', '辽', '辽E'); INSERT INTO `chepaihao` VALUES ('辽宁省', '丹东市', '辽', '辽F'); INSERT INTO `chepaihao` VALUES ('辽宁省', '锦州市', '辽', '辽G'); INSERT INTO `chepaihao` VALUES ('辽宁省', '营口市', '辽', '辽H'); INSERT INTO `chepaihao` VALUES ('辽宁省', '阜新市', '辽', '辽J'); INSERT INTO `chepaihao` VALUES ('辽宁省', '辽阳市', '辽', '辽K'); INSERT INTO `chepaihao` VALUES ('辽宁省', '盘锦市', '辽', '辽L'); INSERT INTO `chepaihao` VALUES ('辽宁省', '铁岭市', '辽', '辽M'); INSERT INTO `chepaihao` VALUES ('辽宁省', '朝阳市', '辽', '辽N'); INSERT INTO `chepaihao` VALUES ('辽宁省', '葫芦岛市', '辽', '辽P'); INSERT INTO `chepaihao` VALUES ('黑龙江省', '哈尔滨市', '黑', '黑A'); INSERT INTO `chepaihao` VALUES ('黑龙江省', '齐齐哈尔市', '黑', '黑B'); INSERT INTO `chepaihao` VALUES ('黑龙江省', '牡丹江市', '黑', '黑C'); INSERT INTO `chepaihao` VALUES ('黑龙江省', '佳木斯市', '黑', '黑D'); INSERT INTO `chepaihao` VALUES ('黑龙江省', '大庆市', '黑', '黑E'); INSERT INTO `chepaihao` VALUES ('黑龙江省', '伊春市', '黑', '黑F'); INSERT INTO `chepaihao` VALUES ('黑龙江省', '鸡西�