------------------------創(chuàng)建pubs數(shù)據(jù)庫(kù)-----------------------
create database pubs;
use pubs;
------------------------創(chuàng)建province表---------------------
create table province
(
id int primary key not null,
name varchar(20) not null,
parentid int not null
)
-------------------------初始化數(shù)據(jù)腳本-------------------------
insert into province(id,name,parentid) values(1,'陜西省',0);
insert into province(id,name,parentid) values(2,'四川省',0);
insert into province(id,name,parentid) values(3,'福建省',0);
insert into province(id,name,parentid) values(4,'寶雞市',1); 
insert into province(id,name,parentid) values(5,'咸陽(yáng)市',1);
insert into province(id,name,parentid) values(6,'漢中市',1);
insert into province(id,name,parentid) values(7,'廣元市',2);
insert into province(id,name,parentid) values(8,'德陽(yáng)市',2);
insert into province(id,name,parentid) values(9,'樂(lè)山市',2);
insert into province(id,name,parentid) values(10,'莆田市',3);
insert into province(id,name,parentid) values(11,'廈門市',3);
insert into province(id,name,parentid) values(12,'泉州市',3);
insert into province(id,name,parentid) values(13,'岐山縣',4);
insert into province(id,name,parentid) values(14,'扶風(fēng)縣',4);
insert into province(id,name,parentid) values(15,'太白縣',4);
insert into province(id,name,parentid) values(16,'武功縣',5);
insert into province(id,name,parentid) values(17,'三原縣',5);
insert into province(id,name,parentid) values(18,'禮泉縣',5);
insert into province(id,name,parentid) values(19,'城固縣',6);
insert into province(id,name,parentid) values(20,'西鄉(xiāng)縣',6);
insert into province(id,name,parentid) values(21,'略陽(yáng)縣',6);
insert into province(id,name,parentid) values(22,'劍閣縣',7); 
insert into province(id,name,parentid) values(23,'旺蒼縣',7);
insert into province(id,name,parentid) values(24,'青川縣',7);
insert into province(id,name,parentid) values(25,'旌陽(yáng)區(qū)',8); 
insert into province(id,name,parentid) values(26,'中江縣',8);
insert into province(id,name,parentid) values(27,'羅江縣',8);
insert into province(id,name,parentid) values(28,'夾江縣',9); 
insert into province(id,name,parentid) values(29,'沐川縣',9);
insert into province(id,name,parentid) values(30,'峨邊縣',9);
insert into province(id,name,parentid) values(31,'城廂區(qū)',10);
insert into province(id,name,parentid) values(32,'涵江區(qū)',10);
insert into province(id,name,parentid) values(33,'荔城區(qū)',10);
insert into province(id,name,parentid) values(34,'思明區(qū)',11); 
insert into province(id,name,parentid) values(35,'海滄區(qū)',11);
insert into province(id,name,parentid) values(36,'湖里區(qū)',11);
insert into province(id,name,parentid) values(37,'惠安縣',12);
insert into province(id,name,parentid) values(38,'永春縣',12);
insert into province(id,name,parentid) values(39,'安溪縣',12);