中国省市数据库表MYSQL版.docx
- 文档编号:3883329
- 上传时间:2022-11-26
- 格式:DOCX
- 页数:17
- 大小:18.98KB
中国省市数据库表MYSQL版.docx
《中国省市数据库表MYSQL版.docx》由会员分享,可在线阅读,更多相关《中国省市数据库表MYSQL版.docx(17页珍藏版)》请在冰豆网上搜索。
中国省市数据库表MYSQL版
中国省市数据库表-MYSQL版
2010-05-1514:
22
DROPTABLEIFEXISTS`province`;
CREATETABLE`province`(
`id`int(11)NOTNULLAUTO_INCREMENT,
`name`varchar(50)DEFAULTNULL,
PRIMARYKEY(`id`)
)ENGINE=InnoDBAUTO_INCREMENT=36DEFAULTCHARSET=gbk;
------------------------------
--Recordsofprovince
------------------------------
INSERTINTO`province`VALUES('1','北京市');
INSERTINTO`province`VALUES('2','天津市');
INSERTINTO`province`VALUES('3','上海市');
INSERTINTO`province`VALUES('4','重庆市');
INSERTINTO`province`VALUES('5','河北省');
INSERTINTO`province`VALUES('6','山西省');
INSERTINTO`province`VALUES('7','台湾省');
INSERTINTO`province`VALUES('8','辽宁省');
INSERTINTO`province`VALUES('9','吉林省');
INSERTINTO`province`VALUES('10','黑龙江省');
INSERTINTO`province`VALUES('11','江苏省');
INSERTINTO`province`VALUES('12','浙江省');
INSERTINTO`province`VALUES('13','安徽省');
INSERTINTO`province`VALUES('14','福建省');
INSERTINTO`province`VALUES('15','江西省');
INSERTINTO`province`VALUES('16','山东省');
INSERTINTO`province`VALUES('17','河南省');
INSERTINTO`province`VALUES('18','湖北省');
INSERTINTO`province`VALUES('19','湖南省');
INSERTINTO`province`VALUES('20','广东省');
INSERTINTO`province`VALUES('21','甘肃省');
INSERTINTO`province`VALUES('22','四川省');
INSERTINTO`province`VALUES('23','贵州省');
INSERTINTO`province`VALUES('24','海南省');
INSERTINTO`province`VALUES('25','云南省');
INSERTINTO`province`VALUES('26','青海省');
INSERTINTO`province`VALUES('27','陕西省');
INSERTINTO`province`VALUES('28','广西壮族自治区');
INSERTINTO`province`VALUES('29','西藏自治区');
INSERTINTO`province`VALUES('30','宁夏回族自治区');
INSERTINTO`province`VALUES('31','新疆维吾尔自治区');
INSERTINTO`province`VALUES('32','内蒙古自治区');
INSERTINTO`province`VALUES('33','澳门特别行政区');
INSERTINTO`province`VALUES('34','香港特别行政区');
------------------------------
--Tablestructurefor`city`
------------------------------
DROPTABLEIFEXISTS`city`;
CREATETABLE`city`(
`id`int(11)NOTNULLAUTO_INCREMENT,
`city_index`int(11)NOTNULL,
`province_id`int(11)NOTNULL,
`name`varchar(100)NOTNULLDEFAULT'',
PRIMARYKEY(`id`)
)ENGINE=InnoDBAUTO_INCREMENT=392DEFAULTCHARSET=gbk;
------------------------------
--Recordsofcity
------------------------------
INSERTINTO`city`VALUES('1','1','1','北京市');
INSERTINTO`city`VALUES('2','1','2','天津市');
INSERTINTO`city`VALUES('3','1','3','上海市');
INSERTINTO`city`VALUES('4','1','4','重庆市');
INSERTINTO`city`VALUES('5','1','5','石家庄市');
INSERTINTO`city`VALUES('6','2','5','唐山市');
INSERTINTO`city`VALUES('7','3','5','秦皇岛市');
INSERTINTO`city`VALUES('8','4','5','邯郸市');
INSERTINTO`city`VALUES('9','5','5','邢台市');
INSERTINTO`city`VALUES('10','6','5','保定市');
INSERTINTO`city`VALUES('11','7','5','张家口市');
INSERTINTO`city`VALUES('12','8','5','承德市');
INSERTINTO`city`VALUES('13','9','5','沧州市');
INSERTINTO`city`VALUES('14','10','5','廊坊市');
INSERTINTO`city`VALUES('15','11','5','衡水市');
INSERTINTO`city`VALUES('16','1','6','太原市');
INSERTINTO`city`VALUES('17','2','6','大同市');
INSERTINTO`city`VALUES('18','3','6','阳泉市');
INSERTINTO`city`VALUES('19','4','6','长治市');
INSERTINTO`city`VALUES('20','5','6','晋城市');
INSERTINTO`city`VALUES('21','6','6','朔州市');
INSERTINTO`city`VALUES('22','7','6','晋中市');
INSERTINTO`city`VALUES('23','8','6','运城市');
INSERTINTO`city`VALUES('24','9','6','忻州市');
INSERTINTO`city`VALUES('25','10','6','临汾市');
INSERTINTO`city`VALUES('26','11','6','吕梁市');
INSERTINTO`city`VALUES('27','1','7','台北市');
INSERTINTO`city`VALUES('28','2','7','高雄市');
INSERTINTO`city`VALUES('29','3','7','基隆市');
INSERTINTO`city`VALUES('30','4','7','台中市');
INSERTINTO`city`VALUES('31','5','7','台南市');
INSERTINTO`city`VALUES('32','6','7','新竹市');
INSERTINTO`city`VALUES('33','7','7','嘉义市');
INSERTINTO`city`VALUES('34','8','7','台北县');
INSERTINTO`city`VALUES('35','9','7','宜兰县');
INSERTINTO`city`VALUES('36','10','7','桃园县');
INSERTINTO`city`VALUES('37','11','7','新竹县');
INSERTINTO`city`VALUES('38','12','7','苗栗县');
INSERTINTO`city`VALUES('39','13','7','台中县');
INSERTINTO`city`VALUES('40','14','7','彰化县');
INSERTINTO`city`VALUES('41','15','7','南投县');
INSERTINTO`city`VALUES('42','16','7','云林县');
INSERTINTO`city`VALUES('43','17','7','嘉义县');
INSERTINTO`city`VALUES('44','18','7','台南县');
INSERTINTO`city`VALUES('45','19','7','高雄县');
INSERTINTO`city`VALUES('46','20','7','屏东县');
INSERTINTO`city`VALUES('47','21','7','澎湖县');
INSERTINTO`city`VALUES('48','22','7','台东县');
INSERTINTO`city`VALUES('49','23','7','花莲县');
INSERTINTO`city`VALUES('50','1','8','沈阳市');
INSERTINTO`city`VALUES('51','2','8','大连市');
INSERTINTO`city`VALUES('52','3','8','鞍山市');
INSERTINTO`city`VALUES('53','4','8','抚顺市');
INSERTINTO`city`VALUES('54','5','8','本溪市');
INSERTINTO`city`VALUES('55','6','8','丹东市');
INSERTINTO`city`VALUES('56','7','8','锦州市');
INSERTINTO`city`VALUES('57','8','8','营口市');
INSERTINTO`city`VALUES('58','9','8','阜新市');
INSERTINTO`city`VALUES('59','10','8','辽阳市');
INSERTINTO`city`VALUES('60','11','8','盘锦市');
INSERTINTO`city`VALUES('61','12','8','铁岭市');
INSERTINTO`city`VALUES('62','13','8','朝阳市');
INSERTINTO`city`VALUES('63','14','8','葫芦岛市');
INSERTINTO`city`VALUES('64','1','9','长春市');
INSERTINTO`city`VALUES('65','2','9','吉林市');
INSERTINTO`city`VALUES('66','3','9','四平市');
INSERTINTO`city`VALUES('67','4','9','辽源市');
INSERTINTO`city`VALUES('68','5','9','通化市');
INSERTINTO`city`VALUES('69','6','9','白山市');
INSERTINTO`city`VALUES('70','7','9','松原市');
INSERTINTO`city`VALUES('71','8','9','白城市');
INSERTINTO`city`VALUES('72','9','9','延边朝鲜族自治州');
INSERTINTO`city`VALUES('73','1','10','哈尔滨市');
INSERTINTO`city`VALUES('74','2','10','齐齐哈尔市');
INSERTINTO`city`VALUES('75','3','10','鹤岗市');
INSERTINTO`city`VALUES('76','4','10','双鸭山市');
INSERTINTO`city`VALUES('77','5','10','鸡西市');
INSERTINTO`city`VALUES('78','6','10','大庆市');
INSERTINTO`city`VALUES('79','7','10','伊春市');
INSERTINTO`city`VALUES('80','8','10','牡丹江市');
INSERTINTO`city`VALUES('81','9','10','佳木斯市');
INSERTINTO`city`VALUES('82','10','10','七台河市');
INSERTINTO`city`VALUES('83','11','10','黑河市');
INSERTINTO`city`VALUES('84','12','10','绥化市');
INSERTINTO`city`VALUES('85','13','10','大兴安岭地区');
INSERTINTO`city`VALUES('86','1','11','南京市');
INSERTINTO`city`VALUES('87','2','11','无锡市');
INSERTINTO`city`VALUES('88','3','11','徐州市');
INSERTINTO`city`VALUES('89','4','11','常州市');
INSERTINTO`city`VALUES('90','5','11','苏州市');
INSERTINTO`city`VALUES('91','6','11','南通市');
INSERTINTO`city`VALUES('92','7','11','连云港市');
INSERTINTO`city`VALUES('93','8','11','淮安市');
INSERTINTO`city`VALUES('94','9','11','盐城市');
INSERTINTO`city`VALUES('95','10','11','扬州市');
INSERTINTO`city`VALUES('96','11','11','镇江市');
INSERTINTO`city`VALUES('97','12','11','泰州市');
INSERTINTO`city`VALUES('98','13','11','宿迁市');
INSERTINTO`city`VALUES('99','1','12','杭州市');
INSERTINTO`city`VALUES('100','2','12','宁波市');
INSERTINTO`city`VALUES('101','3','12','温州市');
INSERTINTO`city`VALUES('102','4','12','嘉兴市');
INSERTINTO`city`VALUES('103','5','12','湖州市');
INSERTINTO`city`VALUES('104','6','12','绍兴市');
INSERTINTO`city`VALUES('105','7','12','金华市');
INSERTINTO`city`VALUES('106','8','12','衢州市');
INSERTINTO`city`VALUES('107','9','12','舟山市');
INSERTINTO`city`VALUES('108','10','12','台州市');
INSERTINTO`city`VALUES('109','11','12','丽水市');
INSERTINTO`city`VALUES('110','1','13','合肥市');
INSERTINTO`city`VALUES('111','2','13','芜湖市');
INSERTINTO`city`VALUES('112','3','13','蚌埠市');
INSERTINTO`city`VALUES('113','4','13','淮南市');
INSERTINTO`city`VALUES('114','5','13','马鞍山市');
INSERTINTO`city`VALUES('115','6','13','淮北市');
INSERTINTO`city`VALUES('116','7','13','铜陵市');
INSERTINTO`city`VALUES('117','8','13','安庆市');
INSERTINTO`city`VALUES('118','9','13','黄山市');
INSERTINTO`city`VALUES('119','10','13','滁州市');
INSERTINTO`city`VALUES('120','11','13','阜阳市');
INSERTINTO`city`VALUES('121','12','13','宿州市');
INSERTINTO`city`VALUES('122','13','13','巢湖市');
INSERTINTO`city`VALUES('123','14','13','六安市');
INSERTINTO`city`VALUES('124','15','13','亳州市');
INSERTINTO`city`VALUES('125','16','13','池州市');
INSERTINTO`city`VALUES('126','17','13','宣城市');
INSERTINTO`city`VALUES('127','1','14','福州市');
INSERTINTO`city`VALUES('128','2','14','厦门市');
INSERTINTO`city`VALUES('129','3','14','莆田市');
INSERTINTO`city`VALUES('130','4','14','三明市');
INSERTINTO`city`VALUES('131','5','14','泉州市');
INSERTINTO`city`VALUES('132','6','14','漳州市');
INSERTINTO`city`VALUES('133','7','14','南平市');
INSERTINTO`city`VALUES('134','8','14','龙岩市');
INSERTINTO`city`VALUES('135','9','14','宁德市');
INSERTINTO`city`VALUES('136','1','15','南昌市');
INSERTINTO`city`VALUES('137','2','15','景德镇市');
INSERTINTO`city`VALUES('138','3','15','萍乡市');
INSERTINTO`city`VALUES('139','4','15','九江市');
INSERTINTO`city`VALUES('140','5','15','新余市');
INSERTINTO`city`VALUES('141','6','15','鹰潭市');
INSERTINTO`city`VALUES('142','7','15','赣州市');
INSERTINTO`city`VALUES('143','8','15','吉安市');
I
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 中国 省市 数据库 MYSQL
![提示](https://static.bdocx.com/images/bang_tan.gif)