Éú³ÉÊ¡ÊеÄSQL½Å±¾

 --Ê¡¼¶   Provincial
--³ÇÊР  City
create table Provincial(pid int,Provincial varchar(50),primary key (pid))
insert into Provincial values(1,'±±¾©ÊÐ')
insert into Provincial values(2,'Ìì½òÊÐ')
insert into Provincial values(3,'ÉϺ£ÊÐ')
insert into Provincial values(4,'ÖØÇìÊÐ')
insert into Provincial values(5,'ºÓ±±Ê¡')
insert into Provincial values(6,'ɽÎ÷Ê¡')
insert into Provincial values(7,'̨ÍåÊ¡')
insert into Provincial values(8,'ÁÉÄþÊ¡')
insert into Provincial values(9,'¼ªÁÖÊ¡')
insert into Provincial values(10,'ºÚÁú½­Ê¡')
insert into Provincial values(11,'½­ËÕÊ¡')
insert into Provincial values(12,'Õã½­Ê¡')
insert into Provincial values(13,'°²»ÕÊ¡')
insert into Provincial values(14,'¸£½¨Ê¡')
insert into Provincial values(15,'½­Î÷Ê¡')
insert into Provincial values(16,'ɽ¶«Ê¡')
insert into Provincial values(17,'ºÓÄÏÊ¡')
insert into Provincial values(18,'ºþ±±Ê¡')
insert into Provincial values(19,'ºþÄÏÊ¡')
insert into Provincial values(20,'¹ã¶«Ê¡')
insert into Provincial values(21,'¸ÊËàÊ¡')
insert into Provincial values(22,'ËÄ´¨Ê¡')
insert into Provincial values(23,'¹óÖÝÊ¡')
insert into Provincial values(24,'º£ÄÏÊ¡')
insert into Provincial values(25,'ÔÆÄÏÊ¡')
insert into Provincial values(26,'Çຣʡ')
insert into Provincial values(27,'ÉÂÎ÷Ê¡')
insert into Provincial values(28,'¹ãÎ÷׳×å×ÔÖÎÇø')
insert into Provincial values(29,'Î÷²Ø×ÔÖÎÇø')
insert into Provincial values(30,'ÄþÏÄ»Ø×å×ÔÖÎÇø')
insert into Provincial values(31,'н®Î¬Îá¶û×ÔÖÎÇø')
insert into Provincial values(32,'ÄÚÃɹÅ×ÔÖÎÇø')
insert into Provincial values(33,'°ÄÃÅÌرðÐÐÕþÇø')
insert into Provincial values(34,'Ïã¸ÛÌرðÐÐÕþÇø')
--select pid,Provincial from Provincial
create table City(cid int not null,city varchar(50) primary key,pid int foreign key references Provincial(pid))
----------------------------------------------------------------------------------------------------------------------------------------
-----------------------------