汽车车牌归属地MYSQL 【belonging】

整理文档很辛苦,赏杯茶钱您下走!

免费阅读已结束,点击下载阅读编辑剩下 ...

阅读已结束,您可以下载文档离线阅读编辑

资源描述

/*NavicatMySQLDataTransferSourceHost:192.168.10.99:3306SourceDatabase:autoTargetHost:192.168.10.99:3306TargetDatabase:autoDate:2012-03-2811:29:15*/SETFOREIGN_KEY_CHECKS=0;--------------------------------Tablestructureforauto_belonging------------------------------DROPTABLEIFEXISTS`auto_belonging`;CREATETABLE`auto_belonging`(`cityid`int(10)NOTNULLAUTO_INCREMENT,`city`varchar(128)NOTNULL,`citycode`char(64)NOTNULL,`provinceid`int(10)NOTNULLDEFAULT'0',PRIMARYKEY(`cityid`))ENGINE=MyISAMAUTO_INCREMENT=426DEFAULTCHARSET=utf8;--------------------------------Recordsofauto_belonging------------------------------INSERTINTO`auto_belonging`VALUES('1','湖南省(湘)','湘','0');INSERTINTO`auto_belonging`VALUES('2','长沙市','湘A','1');INSERTINTO`auto_belonging`VALUES('3','株洲市','湘B','1');INSERTINTO`auto_belonging`VALUES('4','湘潭市','湘C','1');INSERTINTO`auto_belonging`VALUES('5','衡阳市','湘D','1');INSERTINTO`auto_belonging`VALUES('6','邵阳市','湘E','1');INSERTINTO`auto_belonging`VALUES('7','岳阳市','湘F','1');INSERTINTO`auto_belonging`VALUES('8','张家界市','湘G','1');INSERTINTO`auto_belonging`VALUES('9','益阳市','湘H','1');INSERTINTO`auto_belonging`VALUES('10','常德市','湘J','1');INSERTINTO`auto_belonging`VALUES('11','娄底市','湘K','1');INSERTINTO`auto_belonging`VALUES('12','郴州市','湘L','1');INSERTINTO`auto_belonging`VALUES('13','永州市','湘M','1');INSERTINTO`auto_belonging`VALUES('14','怀化市','湘N','1');INSERTINTO`auto_belonging`VALUES('15','湘西土家族苗族自治州','湘U','1');INSERTINTO`auto_belonging`VALUES('16','湖北省(鄂)','鄂','0');INSERTINTO`auto_belonging`VALUES('17','武汉市','鄂A','16');INSERTINTO`auto_belonging`VALUES('18','黄石市','鄂B','16');INSERTINTO`auto_belonging`VALUES('19','十堰市','鄂C','16');INSERTINTO`auto_belonging`VALUES('20','荆州市','鄂D','16');INSERTINTO`auto_belonging`VALUES('21','宜昌市','鄂E','16');INSERTINTO`auto_belonging`VALUES('22','襄樊市','鄂F','16');INSERTINTO`auto_belonging`VALUES('23','鄂州市','鄂G','16');INSERTINTO`auto_belonging`VALUES('24','荆门市','鄂H','16');INSERTINTO`auto_belonging`VALUES('25','黄冈市','鄂J','16');INSERTINTO`auto_belonging`VALUES('26','孝感市','鄂K','16');INSERTINTO`auto_belonging`VALUES('27','咸宁市','鄂L','16');INSERTINTO`auto_belonging`VALUES('28','仙桃市','鄂M','16');INSERTINTO`auto_belonging`VALUES('29','潜江市','鄂N','16');INSERTINTO`auto_belonging`VALUES('30','神农架林区','鄂P','16');INSERTINTO`auto_belonging`VALUES('31','恩施土家族苗族自治州','鄂Q','16');INSERTINTO`auto_belonging`VALUES('32','天门市','鄂R','16');INSERTINTO`auto_belonging`VALUES('33','随州市','鄂S','16');INSERTINTO`auto_belonging`VALUES('34','河南省(豫)','豫','0');INSERTINTO`auto_belonging`VALUES('35','郑州市','豫A','34');INSERTINTO`auto_belonging`VALUES('36','开封市','豫B','34');INSERTINTO`auto_belonging`VALUES('37','洛阳市','豫C','34');INSERTINTO`auto_belonging`VALUES('38','平顶山市','豫D','34');INSERTINTO`auto_belonging`VALUES('39','安阳市','豫E','34');INSERTINTO`auto_belonging`VALUES('40','鹤壁市','豫F','34');INSERTINTO`auto_belonging`VALUES('41','新乡市','豫G','34');INSERTINTO`auto_belonging`VALUES('42','焦作市','豫H','34');INSERTINTO`auto_belonging`VALUES('43','濮阳市','豫J','34');INSERTINTO`auto_belonging`VALUES('44','许昌市','豫K','34');INSERTINTO`auto_belonging`VALUES('45','漯河市','豫L','34');INSERTINTO`auto_belonging`VALUES('46','三门峡市','豫M','34');INSERTINTO`auto_belonging`VALUES('47','商丘市','豫N','34');INSERTINTO`auto_belonging`VALUES('48','周口市','豫P','34');INSERTINTO`auto_belonging`VALUES('49','驻马店市','豫Q','34');INSERTINTO`auto_belonging`VALUES('50','南阳市','豫R','34');INSERTINTO`auto_belonging`VALUES('51','信阳市','豫S','34');INSERTINTO`auto_belonging`VALUES('52','济源市','豫U','34');INSERTINTO`auto_belonging`VALUES('53','河北省(冀)','冀','0');INSERTINTO`auto_belonging`VALUES('54','石家庄市','冀A','53');INSERTINTO`auto_belonging`VALUES('55','唐山市','冀B','53');INSERTINTO`auto_belonging`VALUES('56','秦皇岛市','冀C','53');INSERTINTO`auto_belonging`VALUES('57','邯郸市','冀D','53');INSERTINTO`auto_belonging`VALUES('58','邢台市','冀E','53');INSERTINTO`auto_belonging`VALUES('59','保定市','冀F','53');INSERTINTO`auto_belonging`VALUES('60','张家口市','冀G','53');INSERTINTO`auto_belonging`VALUES('61','承德市','冀H','53');INSERTINTO`auto_belonging`VALUES('62','沧州市','冀J','53');INSERTINTO`auto_belonging`VALUES('63','廊坊市','冀R','53');INSERTINTO`auto_belonging`VALUES('64','沧州市','冀S','53');INSERTINTO`auto_belonging`VALUES('65','衡水市','冀T','53');INSERTINTO`auto_belonging`VALUES('66','云南省(云)','云','0');INSERTINTO`auto_belonging`VALUES('67','昆明市','云A','66');INSERTINTO`auto_belonging`VALUES('68','东川市','云A-V','66');INSERTINTO`auto_belonging`VALUES('69','昭通市','云C','66');INSERTINTO`auto_belonging`VALUES('70','曲靖市','云D','66');INSERTINTO`auto_belonging`VALUES('71','楚雄彝族自治州','云E','66');INSERTINTO`auto_belonging`VALUES('72','玉溪市','云F','66');INSERTINTO`auto_belonging`VALUES('73','红河哈尼族彝族自治州','云G','66');INSERTINTO`auto_belonging`VALUES('74','文山壮族苗族自治州','云H','66');INSERTINTO`auto_belonging`VALUES('75','思茅市','云J','66');INSERTINTO`auto_belonging`VALUES('76','西双版纳傣族自治州','云K','66');INSERTINTO`auto_belonging`VALUES('77','大理白族自治州','云L','66');INSERTINTO`auto_belonging`VALUES('78','保山市','云M','66');INSERTINTO`auto_belonging`VALUES('79','德宏傣族景颇族自治州','云N','66');INSER

1 / 11
下载文档,编辑使用

©2015-2020 m.777doc.com 三七文档.

备案号:鲁ICP备2024069028号-1 客服联系 QQ:2149211541

×
保存成功