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,'°ÄÃÅÌرð