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','...