DELETE FROM  csubdistrict WHERE provcode='50' ;
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','01','01','ศรีภูมิ')   ON DUPLICATE KEY UPDATE subdistname='ศรีภูมิ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','01','02','พระสิงห์')   ON DUPLICATE KEY UPDATE subdistname='พระสิงห์' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','01','03','หายยา')   ON DUPLICATE KEY UPDATE subdistname='หายยา' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','01','04','ช้างม่อย')   ON DUPLICATE KEY UPDATE subdistname='ช้างม่อย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','01','05','ช้างคลาน')   ON DUPLICATE KEY UPDATE subdistname='ช้างคลาน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','01','06','วัดเกต')   ON DUPLICATE KEY UPDATE subdistname='วัดเกต' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','01','07','ช้างเผือก')   ON DUPLICATE KEY UPDATE subdistname='ช้างเผือก' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','01','08','สุเทพ')   ON DUPLICATE KEY UPDATE subdistname='สุเทพ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','01','09','แม่เหียะ')   ON DUPLICATE KEY UPDATE subdistname='แม่เหียะ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','01','10','ป่าแดด')   ON DUPLICATE KEY UPDATE subdistname='ป่าแดด' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','01','11','หนองหอย')   ON DUPLICATE KEY UPDATE subdistname='หนองหอย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','01','12','ท่าศาลา')   ON DUPLICATE KEY UPDATE subdistname='ท่าศาลา' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','01','13','หนองป่าครั่ง')   ON DUPLICATE KEY UPDATE subdistname='หนองป่าครั่ง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','01','14','ฟ้าฮ่าม')   ON DUPLICATE KEY UPDATE subdistname='ฟ้าฮ่าม' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','01','15','ป่าตัน')   ON DUPLICATE KEY UPDATE subdistname='ป่าตัน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','01','16','สันผีเสื้อ')   ON DUPLICATE KEY UPDATE subdistname='สันผีเสื้อ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','02','03','บ้านหลวง')   ON DUPLICATE KEY UPDATE subdistname='บ้านหลวง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','02','04','ข่วงเปา')   ON DUPLICATE KEY UPDATE subdistname='ข่วงเปา' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','02','05','สบเตี๊ยะ')   ON DUPLICATE KEY UPDATE subdistname='สบเตี๊ยะ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','02','06','บ้านแปะ')   ON DUPLICATE KEY UPDATE subdistname='บ้านแปะ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','02','07','ดอยแก้ว')   ON DUPLICATE KEY UPDATE subdistname='ดอยแก้ว' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','02','09','แม่สอย')   ON DUPLICATE KEY UPDATE subdistname='แม่สอย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','03','01','ช่างเคิ่ง')   ON DUPLICATE KEY UPDATE subdistname='ช่างเคิ่ง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','03','02','ท่าผา')   ON DUPLICATE KEY UPDATE subdistname='ท่าผา' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','03','03','บ้านทับ')   ON DUPLICATE KEY UPDATE subdistname='บ้านทับ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','03','04','แม่ศึก')   ON DUPLICATE KEY UPDATE subdistname='แม่ศึก' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','03','05','แม่นาจร')   ON DUPLICATE KEY UPDATE subdistname='แม่นาจร' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','03','06','บ้านจันทร์')   ON DUPLICATE KEY UPDATE subdistname='บ้านจันทร์' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','03','07','ปางหินฝน')   ON DUPLICATE KEY UPDATE subdistname='ปางหินฝน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','03','08','กองแขก')   ON DUPLICATE KEY UPDATE subdistname='กองแขก' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','03','09','แม่แดด')   ON DUPLICATE KEY UPDATE subdistname='แม่แดด' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','03','10','แจ่มหลวง')   ON DUPLICATE KEY UPDATE subdistname='แจ่มหลวง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','04','01','เชียงดาว')   ON DUPLICATE KEY UPDATE subdistname='เชียงดาว' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','04','02','เมืองนะ')   ON DUPLICATE KEY UPDATE subdistname='เมืองนะ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','04','03','เมืองงาย')   ON DUPLICATE KEY UPDATE subdistname='เมืองงาย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','04','04','แม่นะ')   ON DUPLICATE KEY UPDATE subdistname='แม่นะ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','04','05','เมืองคอง')   ON DUPLICATE KEY UPDATE subdistname='เมืองคอง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','04','06','ปิงโค้ง')   ON DUPLICATE KEY UPDATE subdistname='ปิงโค้ง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','04','07','ทุ่งข้าวพวง')   ON DUPLICATE KEY UPDATE subdistname='ทุ่งข้าวพวง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','05','01','เชิงดอย')   ON DUPLICATE KEY UPDATE subdistname='เชิงดอย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','05','02','สันปูเลย')   ON DUPLICATE KEY UPDATE subdistname='สันปูเลย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','05','03','ลวงเหนือ')   ON DUPLICATE KEY UPDATE subdistname='ลวงเหนือ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','05','04','ป่าป้อง')   ON DUPLICATE KEY UPDATE subdistname='ป่าป้อง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','05','05','สง่าบ้าน')   ON DUPLICATE KEY UPDATE subdistname='สง่าบ้าน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','05','06','ป่าลาน')   ON DUPLICATE KEY UPDATE subdistname='ป่าลาน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','05','07','ตลาดขวัญ')   ON DUPLICATE KEY UPDATE subdistname='ตลาดขวัญ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','05','08','สำราญราษฎร์')   ON DUPLICATE KEY UPDATE subdistname='สำราญราษฎร์' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','05','09','แม่คือ')   ON DUPLICATE KEY UPDATE subdistname='แม่คือ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','05','10','ตลาดใหญ่')   ON DUPLICATE KEY UPDATE subdistname='ตลาดใหญ่' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','05','11','แม่ฮ้อยเงิน')   ON DUPLICATE KEY UPDATE subdistname='แม่ฮ้อยเงิน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','05','12','แม่โป่ง')   ON DUPLICATE KEY UPDATE subdistname='แม่โป่ง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','05','13','ป่าเมี่ยง')   ON DUPLICATE KEY UPDATE subdistname='ป่าเมี่ยง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','05','14','เทพเสด็จ')   ON DUPLICATE KEY UPDATE subdistname='เทพเสด็จ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','06','01','สันมหาพน')   ON DUPLICATE KEY UPDATE subdistname='สันมหาพน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','06','02','แม่แตง')   ON DUPLICATE KEY UPDATE subdistname='แม่แตง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','06','03','ขี้เหล็ก')   ON DUPLICATE KEY UPDATE subdistname='ขี้เหล็ก' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','06','04','ช่อแล')   ON DUPLICATE KEY UPDATE subdistname='ช่อแล' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','06','05','แม่หอพระ')   ON DUPLICATE KEY UPDATE subdistname='แม่หอพระ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','06','06','สบเปิง')   ON DUPLICATE KEY UPDATE subdistname='สบเปิง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','06','07','บ้านเป้า')   ON DUPLICATE KEY UPDATE subdistname='บ้านเป้า' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','06','08','สันป่ายาง')   ON DUPLICATE KEY UPDATE subdistname='สันป่ายาง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','06','09','ป่าแป๋')   ON DUPLICATE KEY UPDATE subdistname='ป่าแป๋' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','06','10','เมืองก๋าย')   ON DUPLICATE KEY UPDATE subdistname='เมืองก๋าย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','06','11','บ้านช้าง')   ON DUPLICATE KEY UPDATE subdistname='บ้านช้าง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','06','12','กื้ดช้าง')   ON DUPLICATE KEY UPDATE subdistname='กื้ดช้าง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','06','13','อินทขิล')   ON DUPLICATE KEY UPDATE subdistname='อินทขิล' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','06','14','สมก๋าย')   ON DUPLICATE KEY UPDATE subdistname='สมก๋าย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','07','01','ริมใต้')   ON DUPLICATE KEY UPDATE subdistname='ริมใต้' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','07','02','ริมเหนือ')   ON DUPLICATE KEY UPDATE subdistname='ริมเหนือ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','07','03','สันโป่ง')   ON DUPLICATE KEY UPDATE subdistname='สันโป่ง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','07','04','ขี้เหล็ก')   ON DUPLICATE KEY UPDATE subdistname='ขี้เหล็ก' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','07','05','สะลวง')   ON DUPLICATE KEY UPDATE subdistname='สะลวง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','07','06','ห้วยทราย')   ON DUPLICATE KEY UPDATE subdistname='ห้วยทราย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','07','07','แม่แรม')   ON DUPLICATE KEY UPDATE subdistname='แม่แรม' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','07','08','โป่งแยง')   ON DUPLICATE KEY UPDATE subdistname='โป่งแยง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','07','09','แม่สา')   ON DUPLICATE KEY UPDATE subdistname='แม่สา' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','07','10','ดอนแก้ว')   ON DUPLICATE KEY UPDATE subdistname='ดอนแก้ว' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','07','11','เหมืองแก้ว')   ON DUPLICATE KEY UPDATE subdistname='เหมืองแก้ว' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','08','01','สะเมิงใต้')   ON DUPLICATE KEY UPDATE subdistname='สะเมิงใต้' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','08','02','สะเมิงเหนือ')   ON DUPLICATE KEY UPDATE subdistname='สะเมิงเหนือ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','08','03','แม่สาบ')   ON DUPLICATE KEY UPDATE subdistname='แม่สาบ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','08','04','บ่อแก้ว')   ON DUPLICATE KEY UPDATE subdistname='บ่อแก้ว' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','08','05','ยั้งเมิน')   ON DUPLICATE KEY UPDATE subdistname='ยั้งเมิน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','09','01','เวียง')   ON DUPLICATE KEY UPDATE subdistname='เวียง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','09','03','ม่อนปิ่น')   ON DUPLICATE KEY UPDATE subdistname='ม่อนปิ่น' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','09','04','แม่งอน')   ON DUPLICATE KEY UPDATE subdistname='แม่งอน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','09','05','แม่สูน')   ON DUPLICATE KEY UPDATE subdistname='แม่สูน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','09','06','สันทราย')   ON DUPLICATE KEY UPDATE subdistname='สันทราย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','09','10','แม่คะ')   ON DUPLICATE KEY UPDATE subdistname='แม่คะ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','09','11','แม่ข่า')   ON DUPLICATE KEY UPDATE subdistname='แม่ข่า' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','09','12','โป่งน้ำร้อน')   ON DUPLICATE KEY UPDATE subdistname='โป่งน้ำร้อน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','10','01','แม่อาย')   ON DUPLICATE KEY UPDATE subdistname='แม่อาย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','10','02','แม่สาว')   ON DUPLICATE KEY UPDATE subdistname='แม่สาว' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','10','03','สันต้นหมื้อ')   ON DUPLICATE KEY UPDATE subdistname='สันต้นหมื้อ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','10','04','แม่นาวาง')   ON DUPLICATE KEY UPDATE subdistname='แม่นาวาง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','10','05','ท่าตอน')   ON DUPLICATE KEY UPDATE subdistname='ท่าตอน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','10','06','บ้านหลวง')   ON DUPLICATE KEY UPDATE subdistname='บ้านหลวง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','10','07','มะลิกา')   ON DUPLICATE KEY UPDATE subdistname='มะลิกา' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','11','01','เวียง')   ON DUPLICATE KEY UPDATE subdistname='เวียง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','11','02','ทุ่งหลวง')   ON DUPLICATE KEY UPDATE subdistname='ทุ่งหลวง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','11','03','ป่าตุ้ม')   ON DUPLICATE KEY UPDATE subdistname='ป่าตุ้ม' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','11','04','ป่าไหน่')   ON DUPLICATE KEY UPDATE subdistname='ป่าไหน่' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','11','05','สันทราย')   ON DUPLICATE KEY UPDATE subdistname='สันทราย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','11','06','บ้านโป่ง')   ON DUPLICATE KEY UPDATE subdistname='บ้านโป่ง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','11','07','น้ำแพร่')   ON DUPLICATE KEY UPDATE subdistname='น้ำแพร่' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','11','08','เขื่อนผาก')   ON DUPLICATE KEY UPDATE subdistname='เขื่อนผาก' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','11','09','แม่แวน')   ON DUPLICATE KEY UPDATE subdistname='แม่แวน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','11','10','แม่ปั๋ง')   ON DUPLICATE KEY UPDATE subdistname='แม่ปั๋ง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','11','11','โหล่งขอด')   ON DUPLICATE KEY UPDATE subdistname='โหล่งขอด' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','12','01','ยุหว่า')   ON DUPLICATE KEY UPDATE subdistname='ยุหว่า' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','12','02','สันกลาง')   ON DUPLICATE KEY UPDATE subdistname='สันกลาง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','12','03','ท่าวังพร้าว')   ON DUPLICATE KEY UPDATE subdistname='ท่าวังพร้าว' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','12','04','มะขามหลวง')   ON DUPLICATE KEY UPDATE subdistname='มะขามหลวง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','12','05','แม่ก๊า')   ON DUPLICATE KEY UPDATE subdistname='แม่ก๊า' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','12','06','บ้านแม')   ON DUPLICATE KEY UPDATE subdistname='บ้านแม' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','12','07','บ้านกลาง')   ON DUPLICATE KEY UPDATE subdistname='บ้านกลาง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','12','08','ทุ่งสะโตก')   ON DUPLICATE KEY UPDATE subdistname='ทุ่งสะโตก' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','12','10','ทุ่งต้อม')   ON DUPLICATE KEY UPDATE subdistname='ทุ่งต้อม' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','12','14','น้ำบ่อหลวง')   ON DUPLICATE KEY UPDATE subdistname='น้ำบ่อหลวง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','12','15','มะขุนหวาน')   ON DUPLICATE KEY UPDATE subdistname='มะขุนหวาน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','13','01','สันกำแพง')   ON DUPLICATE KEY UPDATE subdistname='สันกำแพง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','13','02','ทรายมูล')   ON DUPLICATE KEY UPDATE subdistname='ทรายมูล' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','13','03','ร้องวัวแดง')   ON DUPLICATE KEY UPDATE subdistname='ร้องวัวแดง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','13','04','บวกค้าง')   ON DUPLICATE KEY UPDATE subdistname='บวกค้าง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','13','05','แช่ช้าง')   ON DUPLICATE KEY UPDATE subdistname='แช่ช้าง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','13','06','ออนใต้')   ON DUPLICATE KEY UPDATE subdistname='ออนใต้' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','13','10','แม่ปูคา')   ON DUPLICATE KEY UPDATE subdistname='แม่ปูคา' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','13','11','ห้วยทราย')   ON DUPLICATE KEY UPDATE subdistname='ห้วยทราย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','13','12','ต้นเปา')   ON DUPLICATE KEY UPDATE subdistname='ต้นเปา' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','13','13','สันกลาง')   ON DUPLICATE KEY UPDATE subdistname='สันกลาง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','14','01','สันทรายหลวง')   ON DUPLICATE KEY UPDATE subdistname='สันทรายหลวง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','14','02','สันทรายน้อย')   ON DUPLICATE KEY UPDATE subdistname='สันทรายน้อย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','14','03','สันพระเนตร')   ON DUPLICATE KEY UPDATE subdistname='สันพระเนตร' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','14','04','สันนาเม็ง')   ON DUPLICATE KEY UPDATE subdistname='สันนาเม็ง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','14','05','สันป่าเปา')   ON DUPLICATE KEY UPDATE subdistname='สันป่าเปา' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','14','06','หนองแหย่ง')   ON DUPLICATE KEY UPDATE subdistname='หนองแหย่ง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','14','07','หนองจ๊อม')   ON DUPLICATE KEY UPDATE subdistname='หนองจ๊อม' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','14','08','หนองหาร')   ON DUPLICATE KEY UPDATE subdistname='หนองหาร' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','14','09','แม่แฝก')   ON DUPLICATE KEY UPDATE subdistname='แม่แฝก' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','14','10','แม่แฝกใหม่')   ON DUPLICATE KEY UPDATE subdistname='แม่แฝกใหม่' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','14','11','เมืองเล็น')   ON DUPLICATE KEY UPDATE subdistname='เมืองเล็น' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','14','12','ป่าไผ่')   ON DUPLICATE KEY UPDATE subdistname='ป่าไผ่' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','15','01','หางดง')   ON DUPLICATE KEY UPDATE subdistname='หางดง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','15','02','หนองแก๋ว')   ON DUPLICATE KEY UPDATE subdistname='หนองแก๋ว' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','15','03','หารแก้ว')   ON DUPLICATE KEY UPDATE subdistname='หารแก้ว' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','15','04','หนองตอง')   ON DUPLICATE KEY UPDATE subdistname='หนองตอง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','15','05','ขุนคง')   ON DUPLICATE KEY UPDATE subdistname='ขุนคง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','15','06','สบแม่ข่า')   ON DUPLICATE KEY UPDATE subdistname='สบแม่ข่า' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','15','07','บ้านแหวน')   ON DUPLICATE KEY UPDATE subdistname='บ้านแหวน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','15','08','สันผักหวาน')   ON DUPLICATE KEY UPDATE subdistname='สันผักหวาน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','15','09','หนองควาย')   ON DUPLICATE KEY UPDATE subdistname='หนองควาย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','15','10','บ้านปง')   ON DUPLICATE KEY UPDATE subdistname='บ้านปง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','15','11','น้ำแพร่')   ON DUPLICATE KEY UPDATE subdistname='น้ำแพร่' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','16','01','หางดง')   ON DUPLICATE KEY UPDATE subdistname='หางดง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','16','02','ฮอด')   ON DUPLICATE KEY UPDATE subdistname='ฮอด' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','16','03','บ้านตาล')   ON DUPLICATE KEY UPDATE subdistname='บ้านตาล' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','16','04','บ่อหลวง')   ON DUPLICATE KEY UPDATE subdistname='บ่อหลวง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','16','05','บ่อสลี')   ON DUPLICATE KEY UPDATE subdistname='บ่อสลี' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','16','06','นาคอเรือ')   ON DUPLICATE KEY UPDATE subdistname='นาคอเรือ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','17','01','ดอยเต่า')   ON DUPLICATE KEY UPDATE subdistname='ดอยเต่า' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','17','02','ท่าเดื่อ')   ON DUPLICATE KEY UPDATE subdistname='ท่าเดื่อ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','17','03','มืดกา')   ON DUPLICATE KEY UPDATE subdistname='มืดกา' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','17','04','บ้านแอ่น')   ON DUPLICATE KEY UPDATE subdistname='บ้านแอ่น' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','17','05','บงตัน')   ON DUPLICATE KEY UPDATE subdistname='บงตัน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','17','06','โปงทุ่ง')   ON DUPLICATE KEY UPDATE subdistname='โปงทุ่ง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','18','01','อมก๋อย')   ON DUPLICATE KEY UPDATE subdistname='อมก๋อย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','18','02','ยางเปียง')   ON DUPLICATE KEY UPDATE subdistname='ยางเปียง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','18','03','แม่ตื่น')   ON DUPLICATE KEY UPDATE subdistname='แม่ตื่น' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','18','04','ม่อนจอง')   ON DUPLICATE KEY UPDATE subdistname='ม่อนจอง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','18','05','สบโขง')   ON DUPLICATE KEY UPDATE subdistname='สบโขง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','18','06','นาเกียน')   ON DUPLICATE KEY UPDATE subdistname='นาเกียน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','19','01','ยางเนิ้ง')   ON DUPLICATE KEY UPDATE subdistname='ยางเนิ้ง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','19','02','สารภี')   ON DUPLICATE KEY UPDATE subdistname='สารภี' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','19','03','ชมภู')   ON DUPLICATE KEY UPDATE subdistname='ชมภู' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','19','04','ไชยสถาน')   ON DUPLICATE KEY UPDATE subdistname='ไชยสถาน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','19','05','ขัวมุง')   ON DUPLICATE KEY UPDATE subdistname='ขัวมุง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','19','06','หนองแฝก')   ON DUPLICATE KEY UPDATE subdistname='หนองแฝก' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','19','07','หนองผึ้ง')   ON DUPLICATE KEY UPDATE subdistname='หนองผึ้ง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','19','08','ท่ากว้าง')   ON DUPLICATE KEY UPDATE subdistname='ท่ากว้าง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','19','09','ดอนแก้ว')   ON DUPLICATE KEY UPDATE subdistname='ดอนแก้ว' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','19','10','ท่าวังตาล')   ON DUPLICATE KEY UPDATE subdistname='ท่าวังตาล' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','19','11','สันทราย')   ON DUPLICATE KEY UPDATE subdistname='สันทราย' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','19','12','ป่าบง')   ON DUPLICATE KEY UPDATE subdistname='ป่าบง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','20','01','เมืองแหง')   ON DUPLICATE KEY UPDATE subdistname='เมืองแหง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','20','02','เปียงหลวง')   ON DUPLICATE KEY UPDATE subdistname='เปียงหลวง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','20','03','แสนไห')   ON DUPLICATE KEY UPDATE subdistname='แสนไห' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','21','01','ปงตำ')   ON DUPLICATE KEY UPDATE subdistname='ปงตำ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','21','02','ศรีดงเย็น')   ON DUPLICATE KEY UPDATE subdistname='ศรีดงเย็น' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','21','03','แม่ทะลบ')   ON DUPLICATE KEY UPDATE subdistname='แม่ทะลบ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','21','04','หนองบัว')   ON DUPLICATE KEY UPDATE subdistname='หนองบัว' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','22','01','บ้านกาด')   ON DUPLICATE KEY UPDATE subdistname='บ้านกาด' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','22','02','ทุ่งปี้')   ON DUPLICATE KEY UPDATE subdistname='ทุ่งปี้' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','22','03','ทุ่งรวงทอง')   ON DUPLICATE KEY UPDATE subdistname='ทุ่งรวงทอง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','22','04','แม่วิน')   ON DUPLICATE KEY UPDATE subdistname='แม่วิน' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','22','05','ดอนเปา')   ON DUPLICATE KEY UPDATE subdistname='ดอนเปา' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','23','01','ออนเหนือ')   ON DUPLICATE KEY UPDATE subdistname='ออนเหนือ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','23','02','ออนกลาง')   ON DUPLICATE KEY UPDATE subdistname='ออนกลาง' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','23','03','บ้านสหกรณ์')   ON DUPLICATE KEY UPDATE subdistname='บ้านสหกรณ์' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','23','04','ห้วยแก้ว')   ON DUPLICATE KEY UPDATE subdistname='ห้วยแก้ว' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','23','05','แม่ทา')   ON DUPLICATE KEY UPDATE subdistname='แม่ทา' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','23','06','ทาเหนือ')   ON DUPLICATE KEY UPDATE subdistname='ทาเหนือ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','24','01','ดอยหล่อ')   ON DUPLICATE KEY UPDATE subdistname='ดอยหล่อ' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','24','02','สองแคว')   ON DUPLICATE KEY UPDATE subdistname='สองแคว' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','24','03','ยางคราม')   ON DUPLICATE KEY UPDATE subdistname='ยางคราม' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','24','04','สันติสุข')   ON DUPLICATE KEY UPDATE subdistname='สันติสุข' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','25','01','บ้านจันทร์')   ON DUPLICATE KEY UPDATE subdistname='บ้านจันทร์' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','25','02','แม่แดด')   ON DUPLICATE KEY UPDATE subdistname='แม่แดด' ;  
INSERT INTO csubdistrict(provcode,distcode,subdistcode,subdistname) VALUES('50','25','03','แจ่มหลวง')   ON DUPLICATE KEY UPDATE subdistname='แจ่มหลวง' ;