Processing data batch generation SQL INSERT statements

Source: Internet
Author: User
Tags insert

The

has recently been making a weather report module, first of all, we need to convert the client network IP into the city, then the city name to the corresponding city code, found the city code on the Internet, but need to deal with, looked at, there are more than 300 cities and corresponding city code, want to save to the database. Just want to do a data processing automatic generation of SQL statements tool, improve efficiency.

Municipality "Beijing", "Shanghai", "Tianjin", "Chongqing" "101010100", "101020100", "101030100", "101040100" Special Administrative Region "Hong Kong", "Macao" "101320101", "101330101" Heilongjiang "Harbin", "Qiqihar", "Mudanjiang", "Daqing", "Yichun", "Shuangyashan", "Hegang", "Jixi", "Jiamusi", "Qitaihe", "Heihe", "Suihua", "Daxing ' anling" "101050101", " 101050201 "," 101050301 "," 101050901 "," 101050801&q uot;, "101051301", "101051201", "101051101", "101050401", "
    

101051 002 "," 101050601 "," 101050501 "," 101050701 "Jilin" Changchun "," Yanji "," Jilin "," Bss "," Baicheng "," Siping "," Songyuan "," Liaoyuan "," Da-an "," Tonghua " "101060101", "101060301", "101060201", "101060901", "101060601&q uot;," 101060401 "," 101060801 "," 101060701 ","
    

101060603 "," 101060 501 "Liaoning" Shenyang "," Dalian "," Huludao "," Panjin "," Benxi "," Fushun "," Tieling "," Liaoyang "," Yingkou "," Fuxin "," Chaoyang "," Jinzhou "," Dandong "," Anshan " "101070101", "101070201", "101071401", "101071301", "101070501&q uot;," 101070401 "," 101071101 "," 101071001 "," 101070801 "," 101070 901 "," 101071201 "," 101070701 "," 101070601 "," 101070301 "Inner Mongolia" Hohhot "," Hulunbeier "," Xilin Hot "," Baotou "," Chifeng " , "Hailaer", "Wuhai", "Ordos", "Tongliao" "101080101", "101081000", "101080901","101080201", "101080601&q Uot", "101081001", "101080301", "101080701", "101080501" Hebei "Shijiazhuang", "Tangshan", "Zhangjiakou", "Langfang", "Xingtai", "Handan", "Cangzhou", "Hengshui", "Chengde", "Baoding", "Qinhuangdao" "101090101", "101090501", "101090301", "101090601", "101090901&q uot;," 101091001 " , "101090701", "101090801", "101090402", "101090 201", "101091101" Henan "Zhengzhou", "Kaifeng", "Luoyang", "Pingdingshan", "Jiaozuo", "Hebi", "Xinxiang", "Anyang",

"Puyang", "Xuchang", "Luohe", "Sanmenxia", "Nanyang", "Shangqiu", "Xinyang", "Zhoukou", "Zhumadian" "101180101", "101180801", "101180901", "101180501", "101181101&q Uot, "101181201", "101180301", "101180201", "101181301", "101180 401", "101181501", "101181701", "101180701", " 101181001 "," 1 01180601 "," 101181401 "," 101181601 "Shandong" Jinan "," Qingdao "," Zibo "," Weihai "," Qufu "," Linyi "," Yantai "," Zaozhuang "," Liaocheng "," Jining "," Heze ", "Taian", "Sunshine", "Dongying", "Dezhou", "Binzhou", "Laiwu", "Weifang" "101120101", "101120201", "101120301", "101121301", "101120710&q uot;," 10112

0901 "," 101120501 "," 101121401 "," 101121701 "," 101120 701 "," 101121001 "," 101120801 "," 101121501 "," 101121201 "," 1
01120401 "," 101121101 "," 101121601 "," 101120601 "Shanxi    "Taiyuan", "Yangquan," Jincheng "," Jinzhong "," Linfen "," Yuncheng "," Changzhi "," Shuozhou "," Xinzhou "," Datong "," Luliang "" 101100101 "," 101100301 "," 101100601 "," 101100401 "," 101100 701&q Uot, "101100801", "101100501", "101100901", "101101001", "101100 201", "101101101" Jiangsu "Nanjing", "Suzhou", "Kunshan", " Nantong "," Taicang "," Wu County "," Xuzhou, "Yixing", "Zhenjiang", "Huai", "Changshu", "Yancheng", "Taizhou", "Wuxi", "Lianyungang", "Yangzhou", "Changzhou", "Suqian" "101190101", "101190401", "101190404" , "101190501", "101190408&q uot;," 101190406 "," 101190801 "," 101190203 "," 101190301 "," 101190 901 "," 101190402 "," 101190701 "," 101191201 "," 101190201 "," 1 01191001 "," 101190601 "," 101191101 "," 101191301 "Anhui" Hefei "," Chaohu "," Bengbu "," Anqing "," Liu'an "," Chuzhou "," Ma On Shan "," Fuyang "," Xuancheng "," Tongling "," Huaibei "," Wuhu "," Bozhou "," Suzhou "," Huainan "," Chizhou "" 101220101 "," 101221601 "," 101220201 "," 101220601 "," 10 1221501&q Uot;, "101221101", "101220501", "101220801", "101221401", "101221 301", "101221201", "101220301", "
    

101220901 "," 101220701 "," 1 01220401 "," 101221701 "Shaanxi" Xi ' an "," Hancheng "," Ankang "," Hanzhong "," Baoji "," Xianyang "," Yulin "," Weinan "," Shangluo "," Tongchuan "," Yanan " "101110101", "101110510", "101110701", "101110801 "," 101110901&q uot;, "101110200", "101110401", "101110501", "101110601", "101111 001", "101110300" Ningxia "Yinchuan", "
        
Guyuan "," Zhongwei "," Shizuishan "," Wuzhong "" 101170101 "," 101170401 "," 101170501 "," 101170201 "," 101170301&q uot; " Gansu "Lanzhou", "Silver", "Qingyang", "Jiuquan", "Tianshui", "Wuwei", "Zhangye", "Gannan", "Linxia", "Pingliang", "Dingxi", "Jinchang" "101160101", "101161301", "101160401", "10116080 1 "," 101160901&q uot;, "101160501", "101160701", "101050204", "101161101", "101160 301", "101160201", "101160601" green The sea "Xining", "Sea North", "Hercynian", "Huangnan", "Fruit Luo", "Yushu", "Haidong", "Hainan" "101150101", "101150801", "101150701", "101150301", "101150501&q UO t;, "101150601", "101150201", "101150401" Hubei "Wuhan", "Yichang", "Huanggang", "Enshi", "Jingzhou", "Shennongjia", "Shiyan", "Xianning", "Xiangyang", "Xiaogan", "Suizhou", "Huangshi", "Jing Door "," Ezhou "" 101200101 "," 101200901 "," 101200501 "," 101201001 "," 101200801&q uot;, "101201201", "101201101", "101200701

"," 101200201 "," 101200 401 "," 101201301 "," 101200601 "," 101201401 "," 101200301 "Hunan" Changsha "," Shaoyang "," Changde "," Chenzhou "," Jishou "," Zhuzhou "," Loudi "," Xiangtan "," Yiyang "," Yongzhou "," Yueyang "," Hengyang "," Huaihua "," Shaoshan "," Zhangjiajie "
    

"101250101", "101250901", "101250601", "101250501", "101251501&q uot;," 101250301 "," 101250801 "," 101250201 "," 101250701 "," 101251 401 "," 101251001 "," 101250401 "," 101251201 "," 101250202 "," 1 01251101 "Zhejiang" Hangzhou "," Huzhou "," Jinhua "," Ningbo " , "Lishui", "Shaoxing", "Quzhou", "Jiaxing", "Taizhou", "Zhoushan", "Wenzhou" "101210101", "101210201", "101210901", "101210401", "101210801&q uot;," 10121 0501 "," 101211001 "," 101210301 "," 101210601 "," 101211 101 "," 101210701 "Jiangxi" Nanchang "," Pingxiang "," Jiujiang "," Shangrao "," Fuzhou "," Ji "," Yingtan "," Yichun "," Xinyu "," Jingdezhen "," Ganzhou "" 101240101 "," 101240901 "," 101240201 "," 101240301 "," 101240401&q uot;, "101240601", "101241101 "," 101240501 "," 101241001 "," 101240 801 "," 101240701 "Fujian" Fuzhou "," Xiamen "," Longyan "," Nanping "," Ningde "," Putian "," Quanzhou "," sanming "," Zhangzhou "" 101230101 "," 101230201 "," 101230701 "," 101230901 "," 101230301&q uot;, "101230401", "101230501", "101230801", " 101230601 "Guizhou" Guiyang "," Anshun "," Chishui "," Zunyi "," Tongren "," Liupanshui "," Bijie "," Carey "," Duyun "" 101260101 "," 101260301 "," 101260208 "," 1012 60201 "," 101260601&q uot;, "101260801", "101260701 "," 101260501 "," 101260401 "Sichuan" Chengdu "," Luzhou, "Neijiang", "Liangshan", "Aba", "Bazhong", "Guangyuan", "Leshan", "Mianyang", "Deyang", "Panzhihua", "Yaan", "Yibin", "Zigong", "Ganzi State "," Dazhou "," Ziyang "," Guang "," Suining "," Meishan "," Nanchong "" 101270101 "," 101271001 "," 101271201 "," 101271601 "," 101271901&q uot;, "10127090 1 "," 101272101 "," 101271401 "," 101270401 "," 101272 001 "," 101270201 "," 101271701 "," 101271101 "," 101270301 "," 1 01271801 " , "101270601", "101271301", "101270801", "101270701", &q uot;101271501 "," 101270501 "Guangdong" Guangzhou "," Shenzhen "," Chaozhou "," Shaoguan "," Zhan Jiang "," Huizhou "," Qingyuan "," Dongguan "," Jiangmen "," Maoming "," Zhaoqing "," Shanwei "," Heyuan "," Jieyang "," Meizhou "," Zhongshan "," Deqing "," Yangjiang "," Yunfu "," Zhuhai "," Shantou "," Foshan "" 101280101 "," 101280601 "," 101281501 "," 101280201 "," 101281001&q uot;, "101280301", "101281301", "101281601", "101281101", "101282 001", " 101280901 "," 101282101 "," 101281201 "," 101281901 "," 1 01280401 "," 101281701 "," 101280905 "," 101281801 "," 101281401 ", &q uot;101280701 "," 101280501 "," 101280800 "Guangxi" Nanning "," Guilin "," Yangshuo "," Liuzhou "," Wuzhou "," Yulin "," guiping "," Hezhou "," Qinzhou "," Guigang "," Fangchenggang "," Baise "," "Beihai", "Hechi", "Guest", "Chongzuo" "101300101", "101300501","101300510", "101300301", "101300601&q uot;," 101300901 "," 101300802 "," 101300701 "," 101301101 "," 101300 801 "," 101301401 "," 101301001 "," 101301301 "," 101301201 "," 1 01300401 "," 101300201 "Yunnan" Kunming "," Baoshan "," Chuxiong "," Dehong "," Red River "," Lincang "," Nu River "," Qujing "," Simao "," Wenshan "," Yuxi "," Zhaotong "," Lijiang "," Dali "" 101290101 "," 101290501 "," 101290801 "," 101291501 "," 101290301&q uot;, "10
    1291101 "," 101291201 "," 101290401 "," 101290901 "," 101290 601 "," 101290701 "," 101291001 "," 101291401 "," 101290201 "Hainan
        
"Haikou", "Sanya", "Zhanzhou", "Qiongshan", "Tong", "Wenchang" "101310101", "101310201", "101310205", "101310102", "101310222&q Uot;," "101310212" Xinjiang "Urumqi", "Altay", "Aksu", "Changji", "Hami", "Hotan", "Kashi", "Karamay", "Shihezi", "Tacheng", "Korla", "Turpan", "Yining" "101130101", "101131401", "101130801", "101130401", "101131201&q uot;," 101131301 "," 101130901 "," 101130201 "," 101130301 "," 101131 101 "," 101130601 "," 101130501 "," 101131001 "Tibet" Lhasa "," Ali "," Qamdo "," Qu "," Shigatse "," Shannan "," Linzhi "" 101140101 "," 101140701 "," 10 1140501 "," 101140601 "," 101140201&q uot;, "101140301 "," 101140401 "Taiwan" Taipei "," Kaohsiung "" 101340102 "," 101340201 "City Code 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.