代码省市数据库.docVIP

全国全国各个省市数据库 三级联动 MySQL数据库 1.创建promary表 ********************************* create table promary ( proID int primary key, proName varchar(50) not null ); 2.插入中国34个省级行政单位 23个省 5个自治区 4个直辖市 2特别行政区 insert into promary values(1,北京市); insert into promary values(2,天津市); insert into promary values(3,上海市); insert into promary values(4,重庆市); insert into promary values(5,河北省); insert into promary values(6,山西省); insert into promary values(7,台湾省); insert into promary values(8,辽宁省); insert into promary values(9,吉林省); insert into promary values(10,黑龙江省); insert into promary values(11,江苏省); insert into promary values(12,浙江省); insert into promary values(13,安徽省); insert into promary values(14,福建省); insert into promary values(15,江西省); insert into promary values(16,山东省); insert into promary values(17,河南省); insert into promary values(18,湖北省); insert into promary values(19,湖南省); insert into promary values(20,广东省); insert into promary values(21,甘肃省); insert into promary values(22,四川省); insert into promary values(23,贵州省); insert into promary values(24,海南省); insert into promary values(25,云南省); insert into promary values(26,青海省); insert into promary values(27,陕西省); insert into promary values(28,广西壮族自治区); insert into promary values(29,西藏自治区); insert into promary values(30,宁夏回族自治区); insert into promary values(31,新疆维吾尔自治区); insert into promary values(32,内蒙古自治区); insert into promary values(33,澳门特别行政区); insert into promary values(34,香港特别行政区); ---------------------------------------------------------------------------------------------------------------------------------------- 3创建city表********************************************************** create table city ( cityID int not null, cityName varchar(50) primary key, proID int