DROP TABLE IF EXISTS `provinces`;
CREATE TABLE `provinces` (
`id` int(11) NOT NULL auto_increment,
`provinceid` varchar(20) NOT NULL,
`province` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='省份信息表' AUTO_INCREMENT=35 ;
insert into provinces(id,provinceid,province) values(1,'110000','北京市');
insert into provinces(id,provinceid,province) values(2,'120000','天津市');
insert into provinces(id,provinceid,province) values(3,'130000','河北省');
insert into provinces(id,provinceid,province) values(4,'140000','山西省');
insert into provinces(id,provinceid,province) values(5,'150000','内蒙古自治区');
insert into provinces(id,provinceid,province) values(6,'210000','辽宁省');
insert into provinces(id,provinceid,province) values(7,'220000','吉林省');
insert into provinces(id,provinceid,province) values(8,'230000','黑龙江省');
insert into provinces(id,provinceid,province) values(9,'310000','上海市');
insert into provinces(id,provinceid,province) values(10,'320000','江苏省');
insert into provinces(id,provinceid,province) values(11,'330000','浙江省');
insert into provinces(id,provinceid,province) values(12,'340000','安徽省');
insert into provinces(id,provinceid,province) values(13,'350000','福建省');
insert into provinces(id,provinceid,province) values(14,'360000','江西省');
insert into provinces(id,provinceid,province) values(15,'370000','山东省');
insert into provinces(id,provinceid,province) values(16,'410000','河南省');
insert into provinces(id,provinceid,province) values(17,'420000','湖北省');
insert into provinces(id,provinceid,province) values(18,'430000','湖南省');
insert into provinces(id,provinceid,province) values(19,'440000','广东省');
insert into provinces(id,provinceid,province) values(20,'450000','广西壮族自治区');
insert into provinces(id,provinceid,province) values(21,'460000','海南省');
insert into provinces(id,provinceid,province) values(22,'500000','重庆市');
insert into provinces(id,provinceid,province) values(23,'510000','四川省');
insert into provinces(id,provinceid,province) values(24,'520000','贵州省');
insert into provinces(id,provinceid,province) values(25,'530000','云南省');
insert into provinces(id,provinceid,province) values(26,'540000','*自治区');
insert into provinces(id,provinceid,province) values(27,'610000','陕西省');
insert into provinces(id,provinceid,province) values(28,'620000','甘肃省');
insert into provinces(id,provinceid,province) values(29,'630000','青海省');
insert into provinces(id,provinceid,province) values(30,'640000','宁夏回族自治区');
insert into provinces(id,provinceid,province) values(31,'650000','**自治区');
insert into provinces(id,provinceid,province) values(32,'710000','*省');
insert into provinces(id,provinceid,province) values(33,'810000','香港特别行政区');
insert into provinces(id,provinceid,province) values(34,'820000','澳门特别行政区');
相关文章
- 最新全国省市区县乡镇街道行政区划数据和坐标边界数据更新提取(2023年)
- echarts map地图中绘制浙江省市区县乡镇多级联动边界下钻的最新geojson数据文件获取和更新
- ArcGIS QGIS学习二:图层如何只显示需要的部分几何面数据(附最新坐标边界下载全国省市区县乡镇)
- 省市区三级联动select下拉框,下拉框数据回显 Demo js脚本实现带脚本与案例,整理好了的下载既可用
- JAVA使用hutool工具实现查询树结构数据(省市区)
- 全国省市区数据SQL - 省市区
- 全国省市区数据SQL - 省市区
- SQL省市区三级表结构
- C#.NET 大型通用信息化系统集成快速开发平台 4.0 版本 - 省市区数据权限的实现效果
- JS实现Ajax,Josn数据的序列化和反序列化---例: 省市区联动(包含get,post)