Mysql版全国城市列表,下面列出了部分内容:
create table `city` (
`id` varchar (60),
`name` varchar (60),
`pid` varchar (60),
`root` char (3),
`Zone` int (11)
);
insert into `city` (`id`, `name`, `pid`, `root`, `Zone`) values('0001','中国','0000','1','0');
insert into `city` (`id`, `name`, `pid`, `root`, `Zone`) values('11','北京','0001','1','2');
insert into `city` (`id`, `name`, `pid`, `root`, `Zone`) values('1101','北京市辖','11','1','2');
insert into `city` (`id`, `name`, `pid`, `root`, `Zone`) values('110101','东城区','1101','0','2');