python爬虫+mysql数据库
DROP TABLE IF EXISTS `license`;
CREATE TABLE `license` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`brand` char(3) NOT NULL,
`region` varchar(40) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=387 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of license
-- ----------------------------
INSERT INTO `license` VALUES ('1', '冀A', '石家庄市');
INSERT INTO `license` VALUES ('2', '豫A', '郑州市');
INSERT INTO `license` VALUES ('3', '云A', '昆明市');
INSERT INTO `license` VALUES ('4', '冀B', '唐山市');
INSERT INTO `license` VALUES ('5', '豫B', '开封市');
INSERT INTO `license` VALUES ('6', '云A-', '东川区');
INSERT INTO `license` VALUES ('7', '冀C', '秦皇岛市');
INSERT INTO `license` VALUES ('8', '豫C', '洛阳市');
INSERT INTO `license` VALUES ('9', '云C', '昭通市');
INSERT INTO `license` VALUES ('10', '冀D', '邯郸市');
INSERT INTO `license` VALUES ('11', '豫D', '平顶山市');
INSERT INTO `license` VALUES ('12', '云D', '曲靖市');
INSERT INTO `license` VALUES ('13', '冀E', '邢台市');
INSERT INTO `license` VALUES ('14', '豫E', '安阳市');
INSERT INTO `license` VALUES ('15', '云E', '楚雄彝族自治州');
INSERT INTO `license` VALUES ('16', '冀F', '保定市');
INSERT INTO `license` VALUES ('17', '豫F', '鹤壁市');
INSERT INTO `license` VALUES ('18', '云F', '玉溪市');
INSERT INTO `license` VALUES ('19', '冀G', '张家口市');
INSERT INTO `license` VALUES ('20', '豫G', '新乡市');
INSERT INTO `license` VALUES ('21', '云G', '红河哈尼族彝族自治州');
INSERT INTO `license` VALUES ('22', '冀H', '承德市');
INSERT INTO `license` VALUES ('23', '豫H', '焦作市');
INSERT INTO `license` VALUES ('24', '云H', '文山壮族苗族自治州');
INSERT INTO `license` VALUES ('25', '冀J', '沧州市');
INSERT INTO `license` VALUES ('26', '豫J', '濮阳市');
INSERT INTO `license` VALUES ('27', '云J', '思茅区');
INSERT INTO `license` VALUES ('28', '冀R', '廊坊市');
INSERT INTO `license` VALUES ('29', '豫K', '许昌市');
INSERT INTO `license` VALUES ('30', '云K', '西双版纳傣族自治州');
INSERT INTO `license` VALUES ('31', '冀S', '沧州市');
INSERT INTO `license` VALUES ('32', '豫L', '漯河市');
INSERT INTO `license` VALUES ('33', '云L', '大理白族自治州');
INSERT INTO `license` VALUES ('34', '冀T', '衡水市');
INSERT INTO `license` VALUES ('35', '豫M', '三门峡市');
INSERT INTO `license` VALUES ('36', '云M', '保山市');
INSERT INTO `license` VALUES ('37', '豫N', '商丘市');
INSERT INTO `license` VALUES ('38', '云N', '德宏傣族景颇族自治州');
INSERT INTO `license` VALUES ('39', '豫P', '周口市');
INSERT INTO `license` VALUES ('40', '云P', '丽江市');
INSERT INTO `license` VALUES ('41', '豫Q', '驻马店市');
INSERT INTO `license` VALUES ('42', '云Q', '怒江傈僳族自治州');
INSERT INTO `license` VALUES ('43', '豫R', '南阳市');
INSERT INTO `license` VALUES ('44', '云R', '迪庆藏族自治州');
INSERT INTO `license` VALUES ('45', '豫S', '信阳市');
INSERT INTO `license` VALUES ('46', '云S', '临沧市');
INSERT INTO `license` VALUES ('47', '豫U', '济源市');
INSERT INTO `license` VALUES ('48', '辽A', '沈阳市');
INSERT INTO `license` VALUES ('49', '黑A', '哈尔滨市');
INSERT INTO `license` VALUES ('50', '湘A', '长沙市');
INSERT INTO `license` VALUES ('51', '辽B', '大连市');
INSERT INTO `license` VALUES ('52', '黑B', '齐齐哈尔市');
INSERT INTO `license` VALUES ('53', '湘B', '株洲市');
INSERT INTO `license` VALUES ('54', '辽C', '鞍山市');
INSERT INTO `license` VALUES ('55', '黑C', '牡丹江市');
INSERT INTO `license` VALUES ('56', '湘C', '湘潭市');
INSERT INTO `license` VALUES ('57', '辽D', '抚顺市');
INSERT INTO `license` VALUES ('58', '黑D', '佳木斯市');
INSERT INTO `license` VALUES ('59', '湘D', '衡阳市');
INSERT INTO `license` VALUES ('60', '辽E', '本溪市');
INSERT INTO `license` VALUES ('61', '黑E', '大庆市');
INSERT INTO `license` VALUES ('62', '湘E', '邵阳市');
INSERT INTO `license` VALUES ('63', '辽F', '丹东市');
INSERT INTO `license` VALUES ('64', '黑F', '伊春市');
INSERT INTO `license` VALUES ('65', '湘F', '岳阳市');
INSERT INTO `license` VALUES ('66', '辽G', '锦州市');
INSERT INTO `license` VALUES ('67', '黑G', '鸡西市');
INSERT INTO `license` VALUES ('68', '湘G', '张家界市');
INSERT INTO `license` VALUES ('69', '辽H', '营口市');
INSERT INTO `license` VALUES ('70', '黑H', '鹤岗市');
INSERT INTO `license` VALUES ('71', '湘H', '益阳市');
INSERT INTO `license` VALUES ('72', '辽J', '阜新市');
INSERT INTO `license` VALUES ('73', '黑J', '双鸭山市');
INSERT INTO `license` VALUES ('74', '湘J', '常德市');
INSERT INTO `license` VALUES ('75', '辽K', '辽阳市');
INSERT INTO `license` VALUES ('76', '黑K', '七台河市');
INSERT INTO `license` VALUES ('77', '湘K', '娄底市');
INSERT INTO `license` VALUES ('78', '辽L', '盘锦市');
INSERT INTO `license` VALUES ('79', '黑L', '松花江地区(已并入哈尔滨市,车牌未改)');
INSERT INTO `license` VALUES ('80', '湘L', '郴州市');
INSERT INTO `license` VALUES ('81', '辽M', '铁岭市');
INSERT INTO `license` VALUES ('82', '黑M', '绥化市');
INSERT INTO `license` VALUES ('83', '湘M', '永州市');
INSERT INTO `license` VALUES ('84', '辽N', '朝阳市');
INSERT INTO `license` VALUES ('85', '黑N', '黑河市');
INSERT INTO `license` VALUES ('86', '湘N', '怀化市');
INSERT INTO `license` VALUES ('87', '辽P', '葫芦岛市');
INSERT INTO `license` VALUES ('88', '黑P', '大兴安岭地区');
INSERT INTO `license` VALUES ('89', '湘U', '湘西土家族苗族自治州');
INSERT INTO `license` VALUES ('90', '黑R', '农垦系统');
INSERT INTO `license` VALUES ('91', '皖A', '合肥市');
INSERT INTO `license` VALUES ('92', '鲁A', '济南市');
INSERT INTO `license` VALUES ('93', '新A', '乌鲁木齐市');
INSERT INTO `license` VALUES ('94', '皖B', '芜湖市');
INSERT INTO `license` VALUES ('95', '鲁B', '青岛市');
INSERT INTO `license` VALUES ('96', '新B', '昌吉回族自治州');
INSERT INTO `license` VALUES ('97', '皖C', '蚌埠市');
INSERT INTO `license` VALUES ('98', '鲁C', '淄博市');
INSERT INTO `license` VALUES ('99', '新C', '石河子市');
INSERT INTO `license` VALUES ('100', '皖D', '淮南市');
INSERT INTO `license` VALUES ('101', '鲁D', '枣庄市');
INSERT INTO `license` VALUES ('102', '新D', '奎屯市');
INSERT INTO `license` VALUES ('103', '皖E', '马鞍山市');
INSERT INTO `license` VALUES ('104', '鲁E', '东营市');
INSERT INTO `license` VALUES ('105', '新E', '博尔塔拉蒙古自治州');
INSERT INTO `license` VALUES ('106', '皖F', '淮北市');
INSERT INTO `license` VALUES ('107', '鲁F', '烟台市');
INSERT INTO `license` VALUES ('108', '新F', '伊犁哈萨克自治州');
INSERT INTO `license` VALUES ('109', '皖G', '铜陵市');
INSERT INTO `license` VALUES ('110', '鲁G', '潍坊市');
INSERT INTO `license` VALUES ('111', '新G', '塔城地区');
INSERT INTO `license` VALUES ('112', '皖H', '安庆市');
INSERT INTO `license` VALUES ('113', '鲁H', '济宁市');
INSERT INTO `license` VALUES ('114', '新H', '阿勒泰地区');
INSERT INTO `license` VALUES ('115', '皖J', '黄山市');
INSERT INTO `license` VALUES ('116', '鲁J', '泰安市');
INSERT INTO `license` VALUES ('117', '新J', '克拉玛依市');
INSERT INTO `license` VALUES ('118', '皖K', '阜阳市');
INSERT INTO `license` VALUES ('119', '鲁K', '威海市');
INSERT INTO `license` VALUES ('120', '新K', '吐鲁番地区');
INSERT INTO `license` VALUES ('121', '皖L', '宿州市');
INSERT INTO `license` VALUES ('122', '鲁L', '日照市');
INSERT INTO `license` VALUES ('123', '新L', '哈密地区');
INSERT INTO `license` VALUES ('124', '皖M', '滁州市');
INSERT INTO `license` VALUES ('125', '鲁M', '滨州市');
INSERT INTO `license` VALUES ('126', '新M', '巴音郭愣蒙古自治州');
INSERT INTO `license` VALUES ('127', '皖N', '六安市');
INSERT INTO `license` VALUES ('128', '鲁N', '德州市');
INSERT INTO `license` VALUES ('129', '新N', '阿克苏地区');
INSERT INTO `license` VALUES ('130', '皖P', '宣城市');
INSERT INTO `license` VALUES ('131', '鲁P', '聊城市');
INSERT INTO `license` VALUES ('132', '新P', '克孜勒苏柯尔克孜自治州');
INSERT INTO `license` VALUES ('133', '皖Q', '巢湖市');
INSERT INTO `license` VALUES ('134', '鲁Q', '临沂市');
INSERT INTO `license` VALUES ('135', '新Q', '喀什地区');
INSERT INTO `license` VALUES ('136', '皖R', '池州市');
INSERT INTO `license` VALUES ('137', '鲁R', '菏泽市');
INSERT INTO `license` VALUES ('138', '新R', '和田地区');
INSERT INTO `license` VALUES ('139', '皖S', '亳州市');
INSERT INTO `license` VALUES ('140', '鲁S', '莱芜市');
INSERT INTO `license` VALUES ('141', '鲁U', '青岛市');
INSERT INTO `license` VALUES ('142', '鲁V', '潍坊市');
INSERT INTO `license` VALUES ('143', '鲁Y', '烟台市');
INSERT INTO `license` VALUES ('144', '苏A', '南京市');
INSERT INTO `license` VALUES ('145', '浙A', '杭州市');
INSERT INTO `license` VALUES ('146', '赣A', '南昌市');
INSERT INTO `license` VALUES ('147', '苏B', '无锡市');
INSERT INTO `license` VALUES ('148', '浙B', '宁波市');
INSERT INTO `license` VALUES ('149', '赣B', '赣州市');
INSERT INTO `license` VALUES ('150', '苏C', '徐州市');
INSERT INTO `license` VALUES ('151', '浙C', '温州市');
INSERT INTO `license` VALUES ('152', '赣C', '宜春市');
INSERT INTO `license` VALUES ('153', '苏D', '常州市');
INSERT INTO `license` VALUES ('154', '浙D', '绍兴市');
INSERT INTO `license` VALUES ('155', '赣D', '吉安市');
INSERT INTO `license` VALUES ('156', '苏E', '苏州市');
INSERT INTO `license` VALUES ('157', '浙E', '湖州市');
INSERT INTO `license` VALUES ('158', '赣E', '上饶市');
INSERT INTO `license` VALUES ('159', '苏F', '南通市');
INSERT INTO `license` VALUES ('160', '浙F', '嘉兴市');
INSERT INTO `license` VALUES ('161', '赣F', '抚州市');
INSERT INTO `license` VALUES ('162', '苏G', '连云港市');
INSERT INTO `license` VALUES ('163', '浙G', '金华市');
INSERT INTO `license` VALUES ('164', '赣G', '九江市');
INSERT INTO `license` VALUES ('165', '苏H', '淮安市');
INSERT INTO `license` VALUES ('166', '浙H', '衢州市');
INSERT INTO `license` VALUES ('167', '赣H', '景德镇市');
INSERT INTO `license` VALUES ('168', '苏J', '盐城市');
INSERT INTO `license` VALUES ('169', '浙J', '台州市');
INSERT INTO `license` VALUES ('170', '赣J', '萍乡市');
INSERT INTO `license` VALUES ('171', '苏K', '扬州市');
INSERT INTO `license` VALUES ('172', '浙K', '丽水市');
INSERT INTO `license` VALUES ('173', '赣K', '新余市');
INSERT INTO `license` VALUES ('174', '苏L', '镇江市');
INSERT INTO `license` VALUES ('175', '浙L', '舟山市');
INSERT INTO `license` VALUES ('176', '赣L', '鹰潭市');
INSERT INTO `license` VALUES ('177', '苏M', '泰州市');
INSERT INTO `license` VALUES ('178', '赣M', '南昌市');
INSERT INTO `license` VALUES ('179', '苏N', '宿迁市');
INSERT INTO `license` VALUES ('180', '鄂A', '武汉市');
INSERT INTO `license` VALUES ('181', '桂A', '南宁市');
INSERT INTO `license` VALUES ('182', '甘A', '兰州市');
INSERT INTO `license` VALUES ('183', '鄂B', '黄石市');
INSERT INTO `license` VALUES ('184', '桂B', '柳州市');
INSERT INTO `license` VALUES ('185', '甘B', '嘉峪关市');
INSERT INTO `license` VALUES ('186', '鄂C', '十堰市');
INSERT INTO `license` VALUES ('187', '桂C', '桂林市');
INSERT INTO `license` VALUES ('188', '甘C', '金昌市');
INSERT INTO `license` VALUES ('189', '鄂D', '荆州市');
INSERT INTO `license` VALUES ('190', '桂D', '梧州市');
INSERT INTO `license` VALUES ('191', '甘D', '白银市');
INSERT INTO `license` VALUES ('192', '鄂E', '宜昌市');
INSERT INTO `license` VALUES ('193', '桂E', '北海市');
INSERT INTO `license` VALUES ('194', '甘E', '天水市');
INSERT INTO `license` VALUES ('195', '鄂F', '襄樊市');
INSERT INTO `license` VALUES ('196', '桂F', '崇左市');
INSERT INTO `license` VALUES ('197', '甘F', '酒泉市');
INSERT INTO `license` VALUES ('198', '鄂G', '鄂州市');
INSERT INTO `license` VALUES ('199', '桂G', '来宾市');
INSERT INTO `license` VALUES ('200', '甘G', '张掖市');
INSERT INTO `license` VALUES ('201', '鄂H', '荆门市');
INSERT INTO `license` VALUES ('202', '桂H', '桂林市');
INSERT INTO `license` VALUES ('203', '甘H', '武威市');
INSERT INTO `license` VALUES ('204', '鄂J', '黄冈市');
INSERT INTO `license` VALUES ('205', '桂J', '贺州市');
INSERT INTO `license` VALUES ('206', '甘J', '定西市');
INSERT INTO `license` VALUES ('207', '鄂K', '孝感市');
INSERT INTO `license` VALUES ('208', '桂K', '玉林市');
INSERT INTO `license` VALUES ('209', '甘K', '陇南市');
INSERT INTO `license` VALUES ('210', '鄂L', '咸宁市');
INSERT INTO `license` VALUES ('211', '桂L', '百色市');
INSERT INTO `license` VALUES ('212', '甘L', '平凉市');
INSERT INTO `license` VALUES ('213', '鄂M', '仙桃市');
INSERT INTO `license` VALUES ('214', '桂M', '河池市');
INSERT INTO `license` VALUES ('215', '甘M', '庆阳市');
INSERT INTO `license` VALUES ('216', '鄂N', '潜江市');
INSERT INTO `license` VALUES ('217', '桂N', '钦州市');
INSERT INTO `license` VALUES ('218', '甘N', '临夏回族自治州');
INSERT INTO `license` VALUES ('219', '鄂P', '神农架林区');
INSERT INTO `license` VALUES ('220', '桂P', '防城港市');
INSERT INTO `license` VALUES ('221', '甘P', '甘南藏族自治州');
INSERT INTO `license` VALUES ('222', '鄂Q', '恩施土家族苗族自治州');
INSERT INTO `license` VALUES ('223', '桂R', '贵港市');
INSERT INTO `license` VALUES ('224', '鄂R', '天门市');
INSERT INTO `license` VALUES ('225', '鄂S', '随州市');
INSERT INTO `license` VALUES ('226', '晋A', '太原市');
INSERT INTO `license` VALUES ('227', '蒙A', '呼和浩特市');
INSERT INTO `license` VALUES ('228', '陕A', '西安市');
INSERT INTO `license` VALUES ('229', '晋B', '大同市');
INSERT INTO `license` VALUES ('230', '蒙B', '包头市');
INSERT INTO `license` VALUES ('231', '陕B', '铜川市');
INSERT INTO `license` VALUES ('232', '晋C', '阳泉市');
INSERT INTO `license` VALUES ('233', '蒙C', '乌海市');
INSERT INTO `license` VALUES ('234', '陕C', '宝鸡市');
INSERT INTO `license` VALUES ('235', '晋D', '长治市');
INSERT INTO `license` VALUES ('236', '蒙D', '赤峰市');
INSERT INTO `license` VALUES ('237', '陕D', '咸阳市');
INSERT INTO `license` VALUES ('238', '晋E', '晋城市');
INSERT INTO `license` VALUES ('239', '蒙E', '呼伦贝尔市');
INSERT INTO `license` VALUES ('240', '陕E', '渭南市');
INSERT INTO `license` VALUES ('241', '晋F', '朔州市');
INSERT INTO `license` VALUES ('242', '蒙F', '兴安盟');
INSERT INTO `license` VALUES ('243', '陕F', '汉中市');
INSERT INTO `license` VALUES ('244', '晋H', '忻州市');
INSERT INTO `license` VALUES ('245', '蒙G', '通辽市');
INSERT INTO `license` VALUES ('246', '陕G', '安康市');
INSERT INTO `license` VALUES ('247', '晋J', '吕梁市');
INSERT INTO `license` VALUES ('248', '蒙H', '锡林郭勒盟');
INSERT INTO `license` VALUES ('249', '陕H', '商洛市');
INSERT INTO `license` VALUES ('250', '晋K', '晋中市');
INSERT INTO `license` VALUES ('251', '蒙J', '乌兰察布市');
INSERT INTO `license` VALUES ('252', '陕J', '延安市');
INSERT INTO `license` VALUES ('253', '晋L', '临汾市');
INSERT INTO `license` VALUES ('254', '蒙K', '鄂尔多斯市');
INSERT INTO `license` VALUES ('255', '陕K', '榆林市');
INSERT INTO `license` VALUES ('256', '晋M', '运城市');
INSERT INTO `license` VALUES ('257', '蒙L', '巴彦淖尔市');
INSERT INTO `license` VALUES ('258', '陕V', '杨凌区');
INSERT INTO `license` VALUES ('259', '蒙M', '阿拉善盟');
INSERT INTO `license` VALUES ('260', '吉A', '长春市');
INSERT INTO `license` VALUES ('261', '闽A', '福州市');
INSERT INTO `license` VALUES ('262', '贵A', '贵阳市');
INSERT INTO `license` VALUES ('263', '吉B', '吉林市');
INSERT INTO `license` VALUES ('264', '闽B', '莆田市');
INSERT INTO `license` VALUES ('265', '贵B', '六盘水市');
INSERT INTO `license` VALUES ('266', '吉C', '四平市');
INSERT INTO `license` VALUES ('267', '闽C', '泉州市');
INSERT INTO `license` VALUES ('268', '贵C', '遵义市');
INSERT INTO `license` VALUES ('269', '吉D', '辽源市');
INSERT INTO `license` VALUES ('270', '闽D', '厦门市');
INSERT INTO `license` VALUES ('271', '贵D', '铜仁地区');
INSERT INTO `license` VALUES ('272', '吉E', '通化市');
INSERT INTO `license` VALUES ('273', '闽E', '漳州市');
INSERT INTO `license` VALUES ('274', '贵E', '黔西南布依族苗族自治州');
INSERT INTO `license` VALUES ('275', '吉F', '白山市');
INSERT INTO `license` VALUES ('276', '闽F', '龙岩市');
INSERT INTO `license` VALUES ('277', '贵F', '毕节地区');
INSERT INTO `license` VALUES ('278', '吉G', '白城市');
INSERT INTO `license` VALUES ('279', '闽G', '三明市');
INSERT INTO `license` VALUES ('280', '贵G', '安顺市');
INSERT INTO `license` VALUES ('281', '吉H', '延边朝鲜族自治州');
INSERT INTO `license` VALUES ('282', '闽H', '南平市');
INSERT INTO `license` VALUES ('283', '贵H', '黔东南苗族侗族自治州');
INSERT INTO `license` VALUES ('284', '吉J', '松原市');
INSERT INTO `license` VALUES ('285', '闽J', '宁德市');
INSERT INTO `license` VALUES ('286', '贵J', '黔南布依族苗族自治州');
INSERT INTO `license` VALUES ('287', '吉K', '长白朝鲜族自治县');
INSERT INTO `license` VALUES ('288', '闽K', '省直系统');
INSERT INTO `license` VALUES ('289', '粤A', '广州市');
INSERT INTO `license` VALUES ('290', '川A', '成都市');
INSERT INTO `license` VALUES ('291', '青A', '西宁市');
INSERT INTO `license` VALUES ('292', '粤B', '深圳市');
INSERT INTO `license` VALUES ('293', '川B', '绵阳市');
INSERT INTO `license` VALUES ('294', '青B', '海东地区');
INSERT INTO `license` VALUES ('295', '粤C', '珠海市');
INSERT INTO `license` VALUES ('296', '川C', '自贡市');
INSERT INTO `license` VALUES ('297', '青C', '海北藏族自治州');
INSERT INTO `license` VALUES ('298', '粤D', '汕头市');
INSERT INTO `license` VALUES ('299', '川D', '攀枝花市');
INSERT INTO `license` VALUES ('300', '青D', '黄南藏族自治州');
INSERT INTO `license` VALUES ('301', '粤E', '佛山市');
INSERT INTO `license` VALUES ('302', '川E', '泸州市');
INSERT INTO `license` VALUES ('303', '青E', '海南藏族自治州');
INSERT INTO `license` VALUES ('304', '粤F', '韶关市');
INSERT INTO `license` VALUES ('305', '川F', '德阳市');
INSERT INTO `license` VALUES ('306', '青F', '果洛藏族自治州');
INSERT INTO `license` VALUES ('307', '粤G', '湛江市');
INSERT INTO `license` VALUES ('308', '川H', '广元市');
INSERT INTO `license` VALUES ('309', '青G', '玉树藏族自治州');
INSERT INTO `license` VALUES ('310', '粤H', '肇庆市');
INSERT INTO `license` VALUES ('311', '川J', '遂宁市');
INSERT INTO `license` VALUES ('312', '青H', '海西蒙古族藏族自治州');
INSERT INTO `license` VALUES ('313', '粤J', '江门市');
INSERT INTO `license` VALUES ('314', '川K', '内江市');
INSERT INTO `license` VALUES ('315', '粤K', '茂名市');
INSERT INTO `license` VALUES ('316', '川L', '乐山市');
INSERT INTO `license` VALUES ('317', '粤L', '惠州市');
INSERT INTO `license` VALUES ('318', '川M', '资阳市');
INSERT INTO `license` VALUES ('319', '粤M', '梅州市');
INSERT INTO `license` VALUES ('320', '川Q', '宜宾市');
INSERT INTO `license` VALUES ('321', '粤N', '汕尾市');
INSERT INTO `license` VALUES ('322', '川R', '南充市');
INSERT INTO `license` VALUES ('323', '粤P', '河源市');
INSERT INTO `license` VALUES ('324', '川S', '达州市');
INSERT INTO `license` VALUES ('325', '粤Q', '阳江市');
INSERT INTO `license` VALUES ('326', '川T', '雅安市');
INSERT INTO `license` VALUES ('327', '粤R', '清远市');
INSERT INTO `license` VALUES ('328', '川U', '阿坝藏族羌族自治州');
INSERT INTO `license` VALUES ('329', '粤S', '东莞市');
INSERT INTO `license` VALUES ('330', '川V', '甘孜藏族自治州');
INSERT INTO `license` VALUES ('331', '粤T', '中山市');
INSERT INTO `license` VALUES ('332', '川W', '凉山彝族自治州');
INSERT INTO `license` VALUES ('333', '粤U', '潮州市');
INSERT INTO `license` VALUES ('334', '川X', '广安市');
INSERT INTO `license` VALUES ('335', '粤V', '揭阳市');
INSERT INTO `license` VALUES ('336', '川Y', '巴中市');
INSERT INTO `license` VALUES ('337', '粤W', '云浮市');
INSERT INTO `license` VALUES ('338', '川Z', '眉山市');
INSERT INTO `license` VALUES ('339', '粤X', '顺德区');
INSERT INTO `license` VALUES ('340', '粤Y', '南海区');
INSERT INTO `license` VALUES ('341', '粤Z', '港澳进入内地车辆');
INSERT INTO `license` VALUES ('342', '藏A', '拉萨市');
INSERT INTO `license` VALUES ('343', '琼A', '海口市');
INSERT INTO `license` VALUES ('344', '宁A', '银川市');
INSERT INTO `license` VALUES ('345', '藏B', '昌都地区');
INSERT INTO `license` VALUES ('346', '琼B', '三亚市');
INSERT INTO `license` VALUES ('347', '宁B', '石嘴山市');
INSERT INTO `license` VALUES ('348', '藏C', '山南地区');
INSERT INTO `license` VALUES ('349', '琼C', '琼海市');
INSERT INTO `license` VALUES ('350', '宁C', '银南市');
INSERT INTO `license` VALUES ('351', '藏D', '日喀则地区');
INSERT INTO `license` VALUES ('352', '琼D', '五指山市');
INSERT INTO `license` VALUES ('353', '宁D', '固原市');
INSERT INTO `license` VALUES ('354', '藏E', '那曲地区');
INSERT INTO `license` VALUES ('355', '琼E', '洋浦开发区');
INSERT INTO `license` VALUES ('356', '宁E', '中卫市');
INSERT INTO `license` VALUES ('357', '藏F', '阿里地区');
INSERT INTO `license` VALUES ('358', '藏G', '林芝地区');
INSERT INTO `license` VALUES ('359', '藏H', '驻四川省天全县车辆管理所');
INSERT INTO `license` VALUES ('360', '藏J', '驻青海省格尔木市车辆管理所');
INSERT INTO `license` VALUES ('361', '渝A', '重庆市');
INSERT INTO `license` VALUES ('362', '京A', '北京市');
INSERT INTO `license` VALUES ('363', '津A', '天津市');
INSERT INTO `license` VALUES ('364', '渝B', '重庆市');
INSERT INTO `license` VALUES ('365', '京B', '北京市');
INSERT INTO `license` VALUES ('366', '津B', '天津市');
INSERT INTO `license` VALUES ('367', '渝C', '永川区');
INSERT INTO `license` VALUES ('368', '京C', '北京市');
INSERT INTO `license` VALUES ('369', '津C', '天津市');
INSERT INTO `license` VALUES ('370', '渝F', '万州区');
INSERT INTO `license` VALUES ('371', '京D', '北京市');
INSERT INTO `license` VALUES ('372', '津D', '天津市');
INSERT INTO `license` VALUES ('373', '渝G', '涪陵区');
INSERT INTO `license` VALUES ('374', '京E', '北京市');
INSERT INTO `license` VALUES ('375', '津E', '天津市');
INSERT INTO `license` VALUES ('376', '渝H', '黔江区');
INSERT INTO `license` VALUES ('377', '京J', '北京市');
INSERT INTO `license` VALUES ('378', '京K', '北京市');
INSERT INTO `license` VALUES ('379', '京L', '北京市');
INSERT INTO `license` VALUES ('380', '京M', '北京市');
INSERT INTO `license` VALUES ('381', '京Y', '北京市');
INSERT INTO `license` VALUES ('382', '沪A', '上海市');
INSERT INTO `license` VALUES ('383', '沪B', '上海市');
INSERT INTO `license` VALUES ('384', '沪C', '上海市');
INSERT INTO `license` VALUES ('385', '沪D', '上海市');
INSERT INTO `license` VALUES ('386', '沪R', '崇明县');