/*
SQLyog Ultimate v11.27 (32 bit)
MySQL - 5.6.26-log
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
create table `village` (
`ID` int (11),
`Name` varchar (765),
`Code` varchar (9),
`TownID` int (11)
);
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('1','多福巷社区','001','1');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('2','银闸社区','002','1');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('3','菖蒲河社区','003','1');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('4','东厂社区','005','1');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('5','智德社区','006','1');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('6','南池子社区','007','1');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('7','黄图岗社区','008','1');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('8','灯市口社区','009','1');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('9','正义路社区','010','1');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('10','甘雨社区','011','1');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('11','台基厂社区','013','1');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('12','韶九社区','014','1');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('13','王府井社区','015','1');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('14','隆福寺社区','001','2');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('15','吉祥社区','002','2');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('16','黄化门社区','003','2');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('17','钟鼓社区','004','2');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('18','魏家社区','005','2');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('19','汪芝麻社区','006','2');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('20','景山东街社区','008','2');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('21','皇城根北街社区','009','2');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('22','交东社区','001','3');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('23','福祥社区','002','3');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('24','大兴社区','003','3');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('25','细管社区','004','3');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('26','府学社区','005','3');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('27','帽儿社区','006','3');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('28','鼓楼苑社区','007','3');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('29','菊儿社区','008','3');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('30','南锣鼓巷社区','009','3');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('31','圆恩寺社区','010','3');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('32','交北头条社区','001','4');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('33','北锣鼓巷社区','002','4');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('34','国子监社区','003','4');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('35','钟楼湾社区','004','4');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('36','宝钞南社区','005','4');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('37','五道营社区','006','4');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('38','分司厅社区','009','4');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('39','国旺社区','011','4');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('40','花园社区','012','4');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('41','海运仓社区','001','5');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('42','北新仓社区','002','5');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('43','十二条社区','003','5');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('44','门楼社区','004','5');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('45','十三条社区','005','5');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('46','民安社区','006','5');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('47','板桥社区','007','5');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('48','九道湾社区','008','5');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('49','北官厅社区','009','5');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('50','青龙社区','010','5');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('51','小菊社区','011','5');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('52','藏经馆社区','012','5');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('53','炮局社区','013','5');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('54','草园社区','014','5');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('55','二条社区','015','5');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('56','前永康社区','016','5');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('57','南门仓社区','001','6');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('58','七条社区','002','6');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('59','二条社区','003','6');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('60','罗家社区','004','6');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('61','五条社区','005','6');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('62','六条社区','006','6');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('63','豆瓣社区','007','6');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('64','八条社区','008','6');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('65','总院社区','009','6');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('66','九条社区','010','6');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('67','史家社区','001','7');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('68','内务社区','002','7');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('69','演乐社区','003','7');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('70','礼士社区','005','7');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('71','朝内头条社区','006','7');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('72','朝西社区','007','7');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('73','竹杆社区','009','7');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('74','大方家社区','011','7');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('75','新鲜社区','013','7');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('76','东总布社区','004','8');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('77','赵家楼社区','005','8');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('78','西总布社区','006','8');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('79','大雅宝社区','007','8');
insert into `village` (`ID`, `Name`, `Code`, `TownID`) values('80','干面社区','008','8');
ins
评论2
最新资源