------------------------创建pubs数据库-----------------------
create database pubs;
use pubs;
------------------------创建province表---------------------
create table province
(
id int primary key not null,
name varchar(20) not null,
parentid int not null
)
-------------------------初始化数据脚本-------------------------
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,'咸阳市',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,'德阳市',2);
insert into province(id,name,parentid) values(9,'乐山市',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,'扶风县',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,'西乡县',6);
insert into province(id,name,parentid) values(21,'略阳县',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,'旌阳区',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,'城厢区',10);
insert into province(id,name,parentid) values(32,'涵江区',10);
insert into province(id,name,parentid) values(33,'荔城区',10);
insert into province(id,name,parentid) values(34,'思明区',11);
insert into province(id,name,parentid) values(35,'海沧区',11);
insert into province(id,name,parentid) values(36,'湖里区',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);