【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了create_zip.sql相关资料,希望对各位网友有所帮助!
delete from ZIP;
insert into ZIP values (NULL, 100,'台北县','中正区');
insert into ZIP values (NULL, 103,'台北县','大同区');
insert into ZIP values (NULL, 104,'台北县','中山区');
insert into ZIP values (NULL, 105,'台北县','松山区');
insert into ZIP values (NULL, 106,'台北县','大安区');
insert into ZIP values (NULL, 108,'台北县','万华区');
insert into ZIP values (NULL, 110,'台北县','信义区');
insert into ZIP values (NULL, 111,'台北县','士林区');
insert into ZIP values (NULL, 112,'台北县','北投区');
insert into ZIP values (NULL, 114,'台北县','内湖区');
insert into ZIP values (NULL, 115,'台北县','南港区');
insert into ZIP values (NULL, 116,'台北县','文山区');
insert into ZIP values (NULL, 200,'基隆县','仁爱区');
insert into ZIP values (NULL, 201,'基隆县','信义区');
insert into ZIP values (NULL, 202,'基隆县','中正区');
insert into ZIP values (NULL, 203,'基隆县','中山区');
insert into ZIP values (NULL, 204,'基隆县','安乐区');
insert into ZIP values (NULL, 205,'基隆县','暖暖区');
insert into ZIP values (NULL, 206,'基隆县','七堵区');
insert into ZIP values (NULL, 207,'台北县','万里');
insert into ZIP values (NULL, 208,'台北县','金山');
insert into ZIP values (NULL, 220,'台北县','板桥');
insert into ZIP values (NULL, 221,'台北县','汐止');
insert into ZIP values (NULL, 222,'台北县','深坑');
insert into ZIP values (NULL, 223,'台北县','石碇');
insert into ZIP values (NULL, 224,'台北县','瑞芳');
insert into ZIP values (NULL, 226,'台北县','平溪');
insert into ZIP values (NULL, 227,'台北县','双溪');
insert into ZIP values (NULL, 228,'台北县','贡寮');
insert into ZIP values (NULL, 231,'台北县','新店');
insert into ZIP values (NULL, 232,'台北县','坪林');
insert into ZIP values (NULL, 233,'台北县','乌来');
insert into ZIP values (NULL, 234,'台北县','永和');
insert into ZIP values (NULL, 235,'台北县','中和');
insert into ZIP values (NULL, 236,'台北县','土城');
insert into ZIP values (NULL, 237,'台北县','三峡');
insert into ZIP values (NULL, 238,'台北县','树林');
insert into ZIP values (NULL, 239,'台北县','莺歌');
insert into ZIP values (NULL, 241,'台北县','三重');
insert into ZIP values (NULL, 242,'台北县','新庄');
insert into ZIP values (NULL, 243,'台北县','泰山');
insert into ZIP values (NULL, 244,'台北县','林口');
insert into ZIP values (NULL, 247,'台北县','芦洲');
insert into ZIP values (NULL, 248,'台北县','五股');
insert into ZIP values (NULL, 249,'台北县','八里');
insert into ZIP values (NULL, 251,'台北县','淡水');
insert into ZIP values (NULL, 252,'台北县','三芝');
insert into ZIP values (NULL, 253,'台北县','石门');
insert into ZIP values (NULL, 260,'宜兰县','宜兰');
insert into ZIP values (NULL, 261,'宜兰县','头城');
insert into ZIP values (NULL, 262,'宜兰县','礁溪');
insert into ZIP values (NULL, 263,'宜兰县','壮围');
insert into ZIP values (NULL, 264,'宜兰县','员山');
insert into ZIP values (NULL, 265,'宜兰县','罗东');
insert into ZIP values (NULL, 266,'宜兰县','三星');
insert into ZIP values (NULL, 267,'宜兰县','大同');
insert into ZIP values (NULL, 268,'宜兰县','五结');
insert into ZIP values (NULL, 269,'宜兰县','冬山');
insert into ZIP values (NULL, 270,'宜兰县','苏澳');
insert into ZIP values (NULL, 272,'宜兰县','南澳');
insert into ZIP values (NULL, 300,'新竹县','新竹县');
insert into ZIP values (NULL, 302,'新竹县','竹北');
insert into ZIP values (NULL, 303,'新竹县','湖口');
insert into ZIP values (NULL, 304,'新竹县','新丰');
insert into ZIP values (NULL, 305,'新竹县','新埔');
insert into ZIP values (NULL, 306,'新竹县','关西');
insert into ZIP values (NULL, 307,'新竹县','芎林');
insert into ZIP values (NULL, 308,'新竹县','宝山');
insert into ZIP values (NULL, 310,'新竹县','竹东');
insert into ZIP values (NULL, 311,'新竹县','五峰');
insert into ZIP values (NULL, 312,'新竹县','横山');
insert into ZIP values (NULL, 313,'新竹县','尖石');
insert into ZIP values (NULL, 314,'新竹县','北埔');
insert into ZIP values (NULL, 315,'新竹县','峨眉');
insert into ZIP values (NULL, 320,'桃园县','中坜');
insert into ZIP values (NULL, 324,'桃园县','平镇');
insert into ZIP values (NULL, 325,'桃园县','龙潭');
insert into ZIP values (NULL, 326,'桃园县','杨梅');
insert into ZIP values (NULL, 327,'桃园县','新屋');
insert into ZIP values (NULL, 328,'桃园县','观音');
insert into ZIP values (NULL, 330,'桃园县','