📄 zipcodeinsert03.sql
字号:
INSERT INTO ZipCode VALUES ( 100438,'霞晖北村','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100439,'霞晖南村','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100440,'下灰团巷','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100441,'下木场巷','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100442,'新丰新村','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100443,'新丰一村','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100444,'新刮浆坊','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100445,'新荷花弄','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100446,'兴隆路','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100447,'兴隆新村','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100448,'双菱塘','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100449,'双菱新村','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100450,'四季青乡','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100451,'太平门外直街','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100452,'塘苗新村','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100453,'望江路 单1-49号','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100454,'望江门外直街','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100455,'望江铁路新村','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100456,'望江新村','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100457,'夕照新村','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100458,'上灰团巷','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100459,'上木场巷','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100460,'盛家弄','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100461,'始板桥新村','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100462,'始板桥直街','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100463,'双2-102号','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100464,'双2-152号','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100465,'双2-22号','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100466,'双2-90号','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100467,'双92号-完','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100468,'牛污弄','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100469,'清泰街 单1-195号','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100470,'庆春路 单1-35号','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100471,'秋涛路 单239号-完','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100472,'秋涛支线','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100473,'肉厂宿舍','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100474,'阮家弄','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100475,'三多弄','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100476,'三多园','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100477,'商教新村','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100478,'凯旋路 单1-99号','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100479,'凯旋人民新村','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100480,'凯旋铁路新村','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100481,'凯旋新村','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100482,'坤年里','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100483,'老刮浆坊','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100484,'老荷花弄','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100485,'莫邪塘新村','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100486,'木场里','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100487,'南落马营31号-完','310016','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100488,'丁桥乡','310021','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100489,'机场路 单157号-完','310021','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100490,'彭埠镇','310021','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100491,'双16号—完','310021','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100492,'双44号-完','310021','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100493,'笕桥镇','310021','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100494,'艮山路 单33之一-完','310021','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100495,'半山镇','310022','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100496,'长新理','310022','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100497,'上塘桥路','310022','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100498,'石桥乡','310022','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100499,'沿山、皋城村','310022','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100500,'留下镇','310023','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100501,'双96号-完','310023','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100502,'西溪路 单115号-完','310023','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100503,'龙坞乡','310024','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100504,'袁浦乡','310024','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100505,'周浦乡','310024','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100506,'转塘镇','310024','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100507,'中村、村口、金家岭','310038','杭州市','浙江','n');
INSERT INTO ZipCode VALUES ( 100508,'临平镇','311100','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100509,'乾元乡','311100','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100510,'双林乡','311100','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100511,'翁梅乡','311100','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100512,'县城(临平镇','311100','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100513,'小林乡','311100','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100514,'余杭区','311100','浙江','浙江','y');
INSERT INTO ZipCode VALUES ( 100515,'大井乡','311101','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100516,'九堡镇','311101','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100517,'乔司乡','311101','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100518,'万常村、天万村、姚家村、','311101','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100519,'下沙乡','311101','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100520,'亭趾乡','311102','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100521,'博陆乡','311103','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100522,'五杭乡','311103','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100523,'超山乡','311106','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100524,'宏石番乡','311106','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100525,'塘南乡','311106','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100526,'塘栖镇','311106','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100527,'东塘乡','311107','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100528,'章山乡','311107','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100529,'崇贤乡','311108','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100530,'沾桥乡','311109','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100531,'蒋村乡','311111','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100532,'三墩镇','311111','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100533,'双桥乡','311111','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100534,'勾庄乡','311112','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100535,'运河乡','311112','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100536,'肇河乡','311112','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100537,'安溪乡','311113','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100538,'大陆乡','311113','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100539,'良诸镇','311113','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100540,'云会乡','311113','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100541,'五常乡','311114','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100542,'北湖乡','311115','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100543,'长命乡','311115','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100544,'彭公乡','311115','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100545,'瓶窑镇','311115','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100546,'潘板乡','311116','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100547,'双溪乡','311117','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100548,'百丈乡','311118','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100549,'黄湖镇','311118','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100550,'太平乡','311118','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100551,'鸬鸟乡','311118','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100552,'仑前乡','311121','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100553,'石鸽乡','311121','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100554,'泰山乡','311121','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100555,'吴山乡','311121','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100556,'永建乡','311121','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100557,'余杭镇','311121','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100558,'中桥乡','311121','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100559,'舟枕乡','311121','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100560,'和睦乡','311122','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100561,'闲林镇','311122','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100562,'长乐乡','311123','余杭区','浙江','n');
INSERT INTO ZipCode VALUES ( 100563,'萧山区','311200','浙江','浙江','y');
INSERT INTO ZipCode VALUES ( 100564,'大庄乡所属部分村','311203','萧山区','浙江','n');
INSERT INTO ZipCode VALUES ( 100565,'临安市','311300','浙江','浙江','y');
INSERT INTO ZipCode VALUES ( 100566,'临安镇','311300','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100567,'县城(临安镇','311300','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100568,'板桥乡','311301','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100569,'玲珑山乡','311301','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100570,'三口乡','311301','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100571,'上甘乡','311301','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100572,'横溪乡','311304','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100573,'青山镇','311305','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100574,'东天目乡','311306','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100575,'临目乡','311306','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100576,'青云乡','311306','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100577,'杨岭乡','311306','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100578,'高虹乡','311307','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100579,'横畈镇','311307','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100580,'石门乡','311307','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100581,'横路乡','311311','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100582,'凌口乡','311311','临安市','浙江','n');
INSERT INTO ZipCode VALUES ( 100583,'千洪乡','311311','临安市','浙江','n');
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -