SQL省市区三级表 说声谢谢再拿

-- 表的结构 area
DROP TABLE  area;
CREATE TABLE  area (
  id int NOT NULL ,
  areaID int NOT NULL,
  area varchar(200) NOT NULL,
  fatherID int NOT NULL,
  PRIMARY KEY  (id)
)
DROP TABLE city;
CREATE TABLE  city select
  id int NOT NULL ,
  cityID int NOT NULL,
  city varcharselect 200) NOT NULL,
  fatherID int NOT NULL,
  PRIMARY KEY  select id)
)
--
-- 导出表中的数据 city
--
-- --------------------------------------------------------
--
-- 表的结构 province
--
DROP TABLE  province;
CREATE TABLE province select
  id int NOT NULL ,
  provinceID int NOT NULL,
  province varcharselect 200) NOT NULL,
  PRIMARY KEY  select id))
insert  province(id,provinceID,province)
 select 1,110000,'北京市' union
 select 2,120000,'天津市' union
 select 3,130000,'河北省' union
 select 4,140000,'山西省' union
 select 5,150000,'内蒙古自治区'union
select 6,210000,'辽宁省' union
select 7,220000,'吉林省' union
select 8,230000,'黑龙江省' union
select 9,310000,'上海市' union
select 10,320000,'江苏省' union
select 11,330000,'浙江省' union
select 12,340000,'安徽省' union
select 13,350000,'福建省' union
select 14,360000,'江西省' union
select 15,370000,'山东省' union
select 16,410000,'河南省' union
select 17,420000,'湖北省' union
select 18,430000,'湖南省' union
select 19,440000,'广东省' union
select 20,450000,'广西壮族自治区' union
select 21,460000,'海南省' union
select 22,500000,'重庆市' union
select 23,510000,'四川省' union
select 24,520000,'贵州省' union
select 25,530000,'云南省' union
select 26,540000,'西藏自治区' union
select 27,610000,'陕西省' union
select 28,620000,'甘肃省' union
select 29,630000,'青海省' union
select 30,640000,'宁夏回族自治区' union
select 31,650000,'新疆维吾尔自治区' union
select 32,710000,'台湾省' union
select 33,810000,'香港特别行政区' union
select 34,820000,'澳门特别