＜＜オンテック・住所の新規登録用::addr_new.txt＞＞
-- 1: 住所の存在確認(SELECT:count)
SELECT count(*) AS S_1 FROM m_juusho WHERE m_prefectures_id=5 AND shikuchouson_cd=201 AND ooaza_cd=338 AND aza_cd=1;
SELECT count(*) AS S_2 FROM m_juusho WHERE m_prefectures_id=5 AND shikuchouson_cd=201 AND ooaza_cd=338 AND aza_cd=2;
SELECT count(*) AS S_3 FROM m_juusho WHERE m_prefectures_id=5 AND shikuchouson_cd=201 AND ooaza_cd=338 AND aza_cd=3;
SELECT count(*) AS S_4 FROM m_juusho WHERE m_prefectures_id=11 AND shikuchouson_cd=201 AND ooaza_cd=172 AND aza_cd=1;
SELECT count(*) AS S_5 FROM m_juusho WHERE m_prefectures_id=11 AND shikuchouson_cd=201 AND ooaza_cd=172 AND aza_cd=2;
SELECT count(*) AS S_6 FROM m_juusho WHERE m_prefectures_id=11 AND shikuchouson_cd=201 AND ooaza_cd=172 AND aza_cd=3;
SELECT count(*) AS S_7 FROM m_juusho WHERE m_prefectures_id=11 AND shikuchouson_cd=201 AND ooaza_cd=174 AND aza_cd=1;
SELECT count(*) AS S_8 FROM m_juusho WHERE m_prefectures_id=11 AND shikuchouson_cd=201 AND ooaza_cd=174 AND aza_cd=2;
SELECT count(*) AS S_9 FROM m_juusho WHERE m_prefectures_id=11 AND shikuchouson_cd=201 AND ooaza_cd=174 AND aza_cd=3;
SELECT count(*) AS S_10 FROM m_juusho WHERE m_prefectures_id=12 AND shikuchouson_cd=208 AND ooaza_cd=85 AND aza_cd=1;
SELECT count(*) AS S_11 FROM m_juusho WHERE m_prefectures_id=12 AND shikuchouson_cd=208 AND ooaza_cd=85 AND aza_cd=2;
SELECT count(*) AS S_12 FROM m_juusho WHERE m_prefectures_id=12 AND shikuchouson_cd=208 AND ooaza_cd=85 AND aza_cd=3;
SELECT count(*) AS S_13 FROM m_juusho WHERE m_prefectures_id=24 AND shikuchouson_cd=201 AND ooaza_cd=289 AND aza_cd=1;
SELECT count(*) AS S_14 FROM m_juusho WHERE m_prefectures_id=24 AND shikuchouson_cd=201 AND ooaza_cd=289 AND aza_cd=2;
SELECT count(*) AS S_15 FROM m_juusho WHERE m_prefectures_id=24 AND shikuchouson_cd=201 AND ooaza_cd=289 AND aza_cd=3;
SELECT count(*) AS S_16 FROM m_juusho WHERE m_prefectures_id=24 AND shikuchouson_cd=201 AND ooaza_cd=289 AND aza_cd=4;
SELECT count(*) AS S_17 FROM m_juusho WHERE m_prefectures_id=24 AND shikuchouson_cd=201 AND ooaza_cd=289 AND aza_cd=5;
SELECT count(*) AS S_18 FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=231 AND ooaza_cd=12 AND aza_cd=1;
SELECT count(*) AS S_19 FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=231 AND ooaza_cd=12 AND aza_cd=2;
SELECT count(*) AS S_20 FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=231 AND ooaza_cd=12 AND aza_cd=3;
SELECT count(*) AS S_21 FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=231 AND ooaza_cd=12 AND aza_cd=4;
SELECT count(*) AS S_22 FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=231 AND ooaza_cd=12 AND aza_cd=5;
SELECT count(*) AS S_23 FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=231 AND ooaza_cd=12 AND aza_cd=6;
SELECT count(*) AS S_24 FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=231 AND ooaza_cd=12 AND aza_cd=7;
SELECT count(*) AS S_25 FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=231 AND ooaza_cd=12 AND aza_cd=8;

-- 2: 住所の検索＆表示(SELECT)
SELECT * FROM m_juusho WHERE m_prefectures_id=5 AND shikuchouson_cd=201 AND ooaza_cd=338 AND aza_cd=1;
SELECT * FROM m_juusho WHERE m_prefectures_id=5 AND shikuchouson_cd=201 AND ooaza_cd=338 AND aza_cd=2;
SELECT * FROM m_juusho WHERE m_prefectures_id=5 AND shikuchouson_cd=201 AND ooaza_cd=338 AND aza_cd=3;
SELECT * FROM m_juusho WHERE m_prefectures_id=11 AND shikuchouson_cd=201 AND ooaza_cd=172 AND aza_cd=1;
SELECT * FROM m_juusho WHERE m_prefectures_id=11 AND shikuchouson_cd=201 AND ooaza_cd=172 AND aza_cd=2;
SELECT * FROM m_juusho WHERE m_prefectures_id=11 AND shikuchouson_cd=201 AND ooaza_cd=172 AND aza_cd=3;
SELECT * FROM m_juusho WHERE m_prefectures_id=11 AND shikuchouson_cd=201 AND ooaza_cd=174 AND aza_cd=1;
SELECT * FROM m_juusho WHERE m_prefectures_id=11 AND shikuchouson_cd=201 AND ooaza_cd=174 AND aza_cd=2;
SELECT * FROM m_juusho WHERE m_prefectures_id=11 AND shikuchouson_cd=201 AND ooaza_cd=174 AND aza_cd=3;
SELECT * FROM m_juusho WHERE m_prefectures_id=12 AND shikuchouson_cd=208 AND ooaza_cd=85 AND aza_cd=1;
SELECT * FROM m_juusho WHERE m_prefectures_id=12 AND shikuchouson_cd=208 AND ooaza_cd=85 AND aza_cd=2;
SELECT * FROM m_juusho WHERE m_prefectures_id=12 AND shikuchouson_cd=208 AND ooaza_cd=85 AND aza_cd=3;
SELECT * FROM m_juusho WHERE m_prefectures_id=24 AND shikuchouson_cd=201 AND ooaza_cd=289 AND aza_cd=1;
SELECT * FROM m_juusho WHERE m_prefectures_id=24 AND shikuchouson_cd=201 AND ooaza_cd=289 AND aza_cd=2;
SELECT * FROM m_juusho WHERE m_prefectures_id=24 AND shikuchouson_cd=201 AND ooaza_cd=289 AND aza_cd=3;
SELECT * FROM m_juusho WHERE m_prefectures_id=24 AND shikuchouson_cd=201 AND ooaza_cd=289 AND aza_cd=4;
SELECT * FROM m_juusho WHERE m_prefectures_id=24 AND shikuchouson_cd=201 AND ooaza_cd=289 AND aza_cd=5;
SELECT * FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=231 AND ooaza_cd=12 AND aza_cd=1;
SELECT * FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=231 AND ooaza_cd=12 AND aza_cd=2;
SELECT * FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=231 AND ooaza_cd=12 AND aza_cd=3;
SELECT * FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=231 AND ooaza_cd=12 AND aza_cd=4;
SELECT * FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=231 AND ooaza_cd=12 AND aza_cd=5;
SELECT * FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=231 AND ooaza_cd=12 AND aza_cd=6;
SELECT * FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=231 AND ooaza_cd=12 AND aza_cd=7;
SELECT * FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=231 AND ooaza_cd=12 AND aza_cd=8;

-- 3: 住所の新規追加(INSERT INTO)
SET @addr_max_id = (select max(ID) from m_juusho);
INSERT INTO m_juusho(id,region_cd, zipcode, m_prefectures_id, shikuchouson_cd, ooaza_cd, aza_cd, shikuchouson, ooaza, aza, ken) VALUES 
('@addr_max_id+1', '05201338001', '0101420',5,201,338,1,'秋田市','大住南','１丁目','秋田県'),
('@addr_max_id+2', '05201338002', '0101420',5,201,338,2,'秋田市','大住南','２丁目','秋田県'),
('@addr_max_id+3', '05201338003', '0101420',5,201,338,3,'秋田市','大住南','３丁目','秋田県'),
('@addr_max_id+4', '11201172001', '3501159',11,201,172,1,'川越市','中台','１丁目','埼玉県'),
('@addr_max_id+5', '11201172002', '3501159',11,201,172,2,'川越市','中台','２丁目','埼玉県'),
('@addr_max_id+6', '11201172003', '3501159',11,201,172,3,'川越市','中台','３丁目','埼玉県'),
('@addr_max_id+7', '11201174001', '3501150',11,201,174,1,'川越市','中台南','１丁目','埼玉県'),
('@addr_max_id+8', '11201174002', '3501150',11,201,174,2,'川越市','中台南','２丁目','埼玉県'),
('@addr_max_id+9', '11201174003', '3501150',11,201,174,3,'川越市','中台南','３丁目','埼玉県'),
('@addr_max_id+10', '12208085001', '2780057',12,208,85,1,'野田市','光葉町','１丁目','千葉県'),
('@addr_max_id+11', '12208085002', '2780057',12,208,85,2,'野田市','光葉町','２丁目','千葉県'),
('@addr_max_id+12', '12208085003', '2780057',12,208,85,3,'野田市','光葉町','３丁目','千葉県'),
('@addr_max_id+13', '24201289001', '5142222',24,201,289,1,'津市','豊が丘','１丁目','三重県'),
('@addr_max_id+14', '24201289002', '5142222',24,201,289,2,'津市','豊が丘','２丁目','三重県'),
('@addr_max_id+15', '24201289003', '5142222',24,201,289,3,'津市','豊が丘','３丁目','三重県'),
('@addr_max_id+16', '24201289004', '5142222',24,201,289,4,'津市','豊が丘','４丁目','三重県'),
('@addr_max_id+17', '24201289005', '5142222',24,201,289,5,'津市','豊が丘','５丁目','三重県'),
('@addr_max_id+18', '40231012001', '8111203',40,231,12,1,'那珂川市','片縄北','１丁目','福岡県'),
('@addr_max_id+19', '40231012002', '8111203',40,231,12,2,'那珂川市','片縄北','２丁目','福岡県'),
('@addr_max_id+20', '40231012003', '8111203',40,231,12,3,'那珂川市','片縄北','３丁目','福岡県'),
('@addr_max_id+21', '40231012004', '8111203',40,231,12,4,'那珂川市','片縄北','４丁目','福岡県'),
('@addr_max_id+22', '40231012005', '8111203',40,231,12,5,'那珂川市','片縄北','５丁目','福岡県'),
('@addr_max_id+23', '40231012006', '8111203',40,231,12,6,'那珂川市','片縄北','６丁目','福岡県'),
('@addr_max_id+24', '40231012007', '8111203',40,231,12,7,'那珂川市','片縄北','７丁目','福岡県'),
('@addr_max_id+25', '40231012008', '8111203',40,231,12,8,'那珂川市','片縄北','８丁目','福岡県');


＜＜オンテック・住所の更新用::addr_renew.txt＞＞
-- 1: 更新住所の確認(SELECT:count)
SELECT count(*) AS S_1 FROM m_juusho WHERE m_prefectures_id=11 AND shikuchouson_cd=208 AND ooaza_cd=12 AND aza_cd=101;
SELECT count(*) AS S_2 FROM m_juusho WHERE m_prefectures_id=17 AND shikuchouson_cd=209 AND ooaza_cd=32 AND aza_cd=101;
SELECT count(*) AS S_3 FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=349 AND ooaza_cd=6 AND aza_cd=101;
SELECT count(*) AS S_4 FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=349 AND ooaza_cd=25 AND aza_cd=1;
SELECT count(*) AS S_5 FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=349 AND ooaza_cd=25 AND aza_cd=2;
SELECT count(*) AS S_6 FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=349 AND ooaza_cd=25 AND aza_cd=3;
SELECT count(*) AS S_7 FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=349 AND ooaza_cd=25 AND aza_cd=4;

-- 2: 更新住所の検索＆表示(SELECT)
SELECT * FROM m_juusho WHERE m_prefectures_id=11 AND shikuchouson_cd=208 AND ooaza_cd=12 AND aza_cd=101;
SELECT * FROM m_juusho WHERE m_prefectures_id=17 AND shikuchouson_cd=209 AND ooaza_cd=32 AND aza_cd=101;
SELECT * FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=349 AND ooaza_cd=6 AND aza_cd=101;
SELECT * FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=349 AND ooaza_cd=25 AND aza_cd=1;
SELECT * FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=349 AND ooaza_cd=25 AND aza_cd=2;
SELECT * FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=349 AND ooaza_cd=25 AND aza_cd=3;
SELECT * FROM m_juusho WHERE m_prefectures_id=40 AND shikuchouson_cd=349 AND ooaza_cd=25 AND aza_cd=4;

-- 3: 更新住所のUPDATE
UPDATE m_juusho SET Choson='大字亀ケ谷',Aza='字亀寿',PostCD
='3590014
' WHERE m_prefectures_id=11 AND shikuchouson_cd=208 AND ooaza_cd=12 AND aza_cd=101;
UPDATE m_juusho SET Choson='浜北',Aza='壱号',PostCD
='9291174
' WHERE m_prefectures_id=17 AND shikuchouson_cd=209 AND ooaza_cd=32 AND aza_cd=101;
UPDATE m_juusho SET Choson='大字酒殿',Aza='字老ノ木',PostCD
='8112303
' WHERE m_prefectures_id=40 AND shikuchouson_cd=349 AND ooaza_cd=6 AND aza_cd=101;
UPDATE m_juusho SET Choson='戸原北',Aza='１丁目',PostCD
='8112322
' WHERE m_prefectures_id=40 AND shikuchouson_cd=349 AND ooaza_cd=25 AND aza_cd=1;
UPDATE m_juusho SET Choson='戸原北',Aza='２丁目',PostCD
='8112322
' WHERE m_prefectures_id=40 AND shikuchouson_cd=349 AND ooaza_cd=25 AND aza_cd=2;
UPDATE m_juusho SET Choson='戸原北',Aza='３丁目',PostCD
='8112322
' WHERE m_prefectures_id=40 AND shikuchouson_cd=349 AND ooaza_cd=25 AND aza_cd=3;
UPDATE m_juusho SET Choson='戸原北',Aza='４丁目',PostCD
='8112322' WHERE m_prefectures_id=40 AND shikuchouson_cd=349 AND ooaza_cd=25 AND aza_cd=4;