drop table tmptab;

create table tmptab(
tmpid integer primary key,
location varchar(50),
region varchar(50),
postcode varchar(20),
phonecode varchar(20));

insert into tmptab values(1,'北京','北京','100000','010');
insert into tmptab values(2,'通县','北京','101100','010');
insert into tmptab values(3,'昌平','北京','102200','010');
insert into tmptab values(4,'大兴','北京','102600','010');
insert into tmptab values(5,'密云','北京','101500','010');
insert into tmptab values(6,'延庆','北京','102100','010');
insert into tmptab values(7,'顺义','北京','101300','010');
insert into tmptab values(8,'怀柔','北京','101400','010');
insert into tmptab values(9,'平谷','北京','101200','010');
insert into tmptab values(10,'上海','上海','200000','021');
insert into tmptab values(11,'上海县','上海','201100','021');
insert into tmptab values(12,'嘉定','上海','201800','021');
insert into tmptab values(13,'松江','上海','201600','021');
insert into tmptab values(14,'南汇','上海','201300','021');
insert into tmptab values(15,'奉贤','上海','201400','021');
insert into tmptab values(16,'川沙','上海','201200','021');
insert into tmptab values(17,'青浦','上海','201700','021');
insert into tmptab values(18,'崇明','上海','202100','021');
insert into tmptab values(19,'金山','上海','201500','021');
insert into tmptab values(20,'天津','天津','300000','022');
insert into tmptab values(21,'蓟县','天津','301900','022');
insert into tmptab values(22,'宝坻','天津','301800','022');
insert into tmptab values(23,'武清','天津','301700','022');
insert into tmptab values(24,'静海','天津','301600','022');
insert into tmptab values(25,'宁河','天津','301500','022');
insert into tmptab values(26,'万县','重庆','404000','023');
insert into tmptab values(27,'永川','重庆','402000','023');
insert into tmptab values(28,'北碚','重庆','400700','023');
insert into tmptab values(29,'巴县','重庆','401320','023');
insert into tmptab values(30,'江北','重庆','401120','023');
...