全国省市区数据SQL - 省市区

时间:2022-10-26 19:06:00
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','澳门特别行政区');