中国各省市名称数据库建库语句

数据库建库

--创建DBPromary数据库
create database DBPromary
--创建promary表
create table promary
(
proID VARCHAR(2) primary key,
proName varchar(50) not null
)

----------------------------------------------------------------------------------------------------------------------------------------
--中国34个省级行政单位 23个省 5个自治区 4个直辖市 2特别行政区
insert into promary values('01','北京市');
insert into promary values('02','天津市');
insert into promary values('03','上海市');
insert into promary values('04','重庆市');
insert into promary values('05','河北省');
insert into promary values('06','山西省');
insert into promary values('07','台湾省');
insert into promary values('08','辽宁省');
insert into promary values('09','吉林省');
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','香港特别行政区');
----------------------------------------------------------------------------------------------------------------------------------------

--创建city表
create table city
(
cityID VARCHAR(2) not null,
cityName varchar(50) primary key,
proID VARCHAR(2) foreign key references promary(proID)
)


----------------------------------------------------------------------------------------------------------------------------------------
insert into city values('01','北京','01');
insert into city values('01','上海','03');
insert into city values('01','天津','02');
insert into city values('01','重庆','04');
insert into city values('01','辽阳市','08');
insert into city values('02','大连市','08');
insert into city values('03','鞍山市','08');
insert into city values('04','抚顺市','08');
insert into city values('05','本溪市','08');
insert into city values('06','丹东市','08');
inse