史上最全的快遞公司編碼大全（附sql）

create table sys_express
(
    id            bigint auto_increment comment '主鍵ID'
        primary key,
    express_code  varchar(50) default '' not null comment '物流公司簡稱',
    express_name  varchar(50) default '' not null comment '物流公司全稱',
    is_used       tinyint(1)  default 0  null comment '是否常用 0否 1是',
    sort_no       int                    null comment '排序',
    enabled_state tinyint(1)  default 1  null comment '啟用狀態(tài)',
    gmt_create    datetime               null comment '創(chuàng)建時間',
    gmt_modify    datetime               null comment '修改時間',
    create_by     bigint                 null comment '創(chuàng)建人',
    modify_by     bigint                 null comment '修改人',
    active        tinyint(1)  default 1  null comment '是否有效'
)
    comment '物流公司表';

INSERT INTO sys_express (express_name,express_code) VALUES ('順豐速運','SF');
INSERT INTO sys_express (express_name,express_code) VALUES ('百世快遞','HTKY');
INSERT INTO sys_express (express_name,express_code) VALUES ('中通快遞','ZTO');
INSERT INTO sys_express (express_name,express_code) VALUES ('申通快遞','STO');
INSERT INTO sys_express (express_name,express_code) VALUES ('圓通速遞','YTO');
INSERT INTO sys_express (express_name,express_code) VALUES ('韻達速遞','YD');
INSERT INTO sys_express (express_name,express_code) VALUES ('郵政快遞包裹','YZPY');
INSERT INTO sys_express (express_name,express_code) VALUES ('EMS','EMS');
INSERT INTO sys_express (express_name,express_code) VALUES ('天天快遞','HHTT');
INSERT INTO sys_express (express_name,express_code) VALUES ('京東快遞','JD');
INSERT INTO sys_express (express_name,express_code) VALUES ('優(yōu)速快遞','UC');
INSERT INTO sys_express (express_name,express_code) VALUES ('德邦快遞','DBL');
INSERT INTO sys_express (express_name,express_code) VALUES ('宅急送','ZJS');
INSERT INTO sys_express (express_name,express_code) VALUES ('TNT快遞','TNT');
INSERT INTO sys_express (express_name,express_code) VALUES ('UPS','UPS');
INSERT INTO sys_express (express_name,express_code) VALUES ('DHL','DHL');
INSERT INTO sys_express (express_name,express_code) VALUES ('FEDEX聯(lián)邦(國內(nèi)件）','FEDEX');
INSERT INTO sys_express (express_name,express_code) VALUES ('FEDEX聯(lián)邦(國際件）','FEDEX_GJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('安捷快遞','AJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('阿里跨境電商物流','ALKJWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('安迅物流','AX');
INSERT INTO sys_express (express_name,express_code) VALUES ('安郵美國','AYUS');
INSERT INTO sys_express (express_name,express_code) VALUES ('亞馬遜物流','AMAZON');
INSERT INTO sys_express (express_name,express_code) VALUES ('澳門郵政','AOMENYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('安能物流','ANE');
INSERT INTO sys_express (express_name,express_code) VALUES ('澳多多','ADD');
INSERT INTO sys_express (express_name,express_code) VALUES ('澳郵專線','AYCA');
INSERT INTO sys_express (express_name,express_code) VALUES ('安鮮達','AXD');
INSERT INTO sys_express (express_name,express_code) VALUES ('安能快運','ANEKY');
INSERT INTO sys_express (express_name,express_code) VALUES ('八達通','BDT');
INSERT INTO sys_express (express_name,express_code) VALUES ('百騰物流','BETWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('北極星快運','BJXKY');
INSERT INTO sys_express (express_name,express_code) VALUES ('奔騰物流','BNTWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('百福東方','BFDF');
INSERT INTO sys_express (express_name,express_code) VALUES ('貝海國際','BHGJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('八方安運','BFAY');
INSERT INTO sys_express (express_name,express_code) VALUES ('百世快運','BTWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('春風物流','CFWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('誠通物流','CHTWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('傳喜物流','CXHY');
INSERT INTO sys_express (express_name,express_code) VALUES ('程光','CG');
INSERT INTO sys_express (express_name,express_code) VALUES ('城市100','CITY100');
INSERT INTO sys_express (express_name,express_code) VALUES ('城際快遞','CJKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('CNPEX中郵快遞','CNPEX');
INSERT INTO sys_express (express_name,express_code) VALUES ('COE東方快遞','COE');
INSERT INTO sys_express (express_name,express_code) VALUES ('長沙創(chuàng)一','CSCY');
INSERT INTO sys_express (express_name,express_code) VALUES ('成都善途速運','CDSTKY');
INSERT INTO sys_express (express_name,express_code) VALUES ('聯(lián)合運通','CTG');
INSERT INTO sys_express (express_name,express_code) VALUES ('瘋狂快遞','CRAZY');
INSERT INTO sys_express (express_name,express_code) VALUES ('CBO釧博物流','CBO');
INSERT INTO sys_express (express_name,express_code) VALUES ('承諾達','CND');
INSERT INTO sys_express (express_name,express_code) VALUES ('D速物流','DSWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('到了港','DLG');
INSERT INTO sys_express (express_name,express_code) VALUES ('大田物流','DTWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('東駿快捷物流','DJKJWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('德坤','DEKUN');
INSERT INTO sys_express (express_name,express_code) VALUES ('德邦快運','DBLKY');
INSERT INTO sys_express (express_name,express_code) VALUES ('大馬鹿','DML');
INSERT INTO sys_express (express_name,express_code) VALUES ('E特快','ETK');
INSERT INTO sys_express (express_name,express_code) VALUES ('EWE','EWE');
INSERT INTO sys_express (express_name,express_code) VALUES ('快服務(wù)','KFW');
INSERT INTO sys_express (express_name,express_code) VALUES ('飛康達','FKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('富騰達','FTD');
INSERT INTO sys_express (express_name,express_code) VALUES ('凡宇貨的','FYKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('速派快遞','FASTGO');
INSERT INTO sys_express (express_name,express_code) VALUES ('豐通快運','FT');
INSERT INTO sys_express (express_name,express_code) VALUES ('冠達','GD');
INSERT INTO sys_express (express_name,express_code) VALUES ('國通快遞','GTO');
INSERT INTO sys_express (express_name,express_code) VALUES ('廣東郵政','GDEMS');
INSERT INTO sys_express (express_name,express_code) VALUES ('共速達','GSD');
INSERT INTO sys_express (express_name,express_code) VALUES ('廣通','GTONG');
INSERT INTO sys_express (express_name,express_code) VALUES ('迦遞快遞','GAI');
INSERT INTO sys_express (express_name,express_code) VALUES ('港快速遞','GKSD');
INSERT INTO sys_express (express_name,express_code) VALUES ('高鐵速遞','GTSD');
INSERT INTO sys_express (express_name,express_code) VALUES ('匯豐物流','HFWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('黑狗冷鏈','HGLL');
INSERT INTO sys_express (express_name,express_code) VALUES ('恒路物流','HLWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('天地華宇','HOAU');
INSERT INTO sys_express (express_name,express_code) VALUES ('鴻橋供應(yīng)鏈','HOTSCM');
INSERT INTO sys_express (express_name,express_code) VALUES ('海派通物流公司','HPTEX');
INSERT INTO sys_express (express_name,express_code) VALUES ('華強物流','hq568');
INSERT INTO sys_express (express_name,express_code) VALUES ('環(huán)球速運','HQSY');
INSERT INTO sys_express (express_name,express_code) VALUES ('華夏龍物流','HXLWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('豪翔物流','HXWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('合肥匯文','HFHW');
INSERT INTO sys_express (express_name,express_code) VALUES ('輝隆物流','HLONGWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('華企快遞','HQKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('韓潤物流','HRWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('青島恒通快遞','HTKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('貨運皇物流','HYH');
INSERT INTO sys_express (express_name,express_code) VALUES ('好來運快遞','HYLSD');
INSERT INTO sys_express (express_name,express_code) VALUES ('皇家物流','HJWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('捷安達','JAD');
INSERT INTO sys_express (express_name,express_code) VALUES ('京廣速遞','JGSD');
INSERT INTO sys_express (express_name,express_code) VALUES ('九曳供應(yīng)鏈','JIUYE');
INSERT INTO sys_express (express_name,express_code) VALUES ('急先達','JXD');
INSERT INTO sys_express (express_name,express_code) VALUES ('晉越快遞','JYKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('加運美','JYM');
INSERT INTO sys_express (express_name,express_code) VALUES ('景光物流','JGWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('佳怡物流','JYWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('京東快運','JDKY');
INSERT INTO sys_express (express_name,express_code) VALUES ('佳吉快運','CNEX');
INSERT INTO sys_express (express_name,express_code) VALUES ('跨越速運','KYSY');
INSERT INTO sys_express (express_name,express_code) VALUES ('跨越物流','KYWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('快速遞物流','KSDWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('快8速運','KBSY');
INSERT INTO sys_express (express_name,express_code) VALUES ('龍邦快遞','LB');
INSERT INTO sys_express (express_name,express_code) VALUES ('立即送','LJSKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('聯(lián)昊通速遞','LHT');
INSERT INTO sys_express (express_name,express_code) VALUES ('民邦快遞','MB');
INSERT INTO sys_express (express_name,express_code) VALUES ('民航快遞','MHKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('美快','MK');
INSERT INTO sys_express (express_name,express_code) VALUES ('門對門快遞','MDM');
INSERT INTO sys_express (express_name,express_code) VALUES ('邁隆遞運','MRDY');
INSERT INTO sys_express (express_name,express_code) VALUES ('明亮物流','MLWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('南方','NF');
INSERT INTO sys_express (express_name,express_code) VALUES ('能達速遞','NEDA');
INSERT INTO sys_express (express_name,express_code) VALUES ('平安達騰飛快遞','PADTF');
INSERT INTO sys_express (express_name,express_code) VALUES ('泛捷快遞','PANEX');
INSERT INTO sys_express (express_name,express_code) VALUES ('品駿快遞','PJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('全晨快遞','QCKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('全日通快遞','QRT');
INSERT INTO sys_express (express_name,express_code) VALUES ('快客快遞','QUICK');
INSERT INTO sys_express (express_name,express_code) VALUES ('全信通','QXT');
INSERT INTO sys_express (express_name,express_code) VALUES ('榮慶物流','RQ');
INSERT INTO sys_express (express_name,express_code) VALUES ('七曜中郵','QYZY');
INSERT INTO sys_express (express_name,express_code) VALUES ('如風達','RFD');
INSERT INTO sys_express (express_name,express_code) VALUES ('日日順物流','RRS');
INSERT INTO sys_express (express_name,express_code) VALUES ('瑞豐速遞','RFEX');
INSERT INTO sys_express (express_name,express_code) VALUES ('賽澳遞','SAD');
INSERT INTO sys_express (express_name,express_code) VALUES ('蘇寧物流','SNWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('圣安物流','SAWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('晟邦物流','SBWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('上大物流','SDWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('盛豐物流','SFWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('速通物流','ST');
INSERT INTO sys_express (express_name,express_code) VALUES ('速騰快遞','STWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('速必達物流','SUBIDA');
INSERT INTO sys_express (express_name,express_code) VALUES ('速遞e站','SDEZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('速呈宅配','SCZPDS');
INSERT INTO sys_express (express_name,express_code) VALUES ('速爾快遞','SURE');
INSERT INTO sys_express (express_name,express_code) VALUES ('閃送','SS');
INSERT INTO sys_express (express_name,express_code) VALUES ('盛通快遞','STKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('臺灣郵政','TAIWANYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('唐山申通','TSSTO');
INSERT INTO sys_express (express_name,express_code) VALUES ('特急送','TJS');
INSERT INTO sys_express (express_name,express_code) VALUES ('通用物流','TYWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('騰林物流','TLWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('全一快遞','UAPEX');
INSERT INTO sys_express (express_name,express_code) VALUES ('優(yōu)聯(lián)吉運','ULUCKEX');
INSERT INTO sys_express (express_name,express_code) VALUES ('萬家康','WJK');
INSERT INTO sys_express (express_name,express_code) VALUES ('萬家物流','WJWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('武漢同舟行','WHTZX');
INSERT INTO sys_express (express_name,express_code) VALUES ('維普恩','WPE');
INSERT INTO sys_express (express_name,express_code) VALUES ('萬象物流','WXWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('微特派','WTP');
INSERT INTO sys_express (express_name,express_code) VALUES ('溫通物流','WTWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('迅馳物流','XCWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('信豐物流','XFEX');
INSERT INTO sys_express (express_name,express_code) VALUES ('希優(yōu)特','XYT');
INSERT INTO sys_express (express_name,express_code) VALUES ('新杰物流','XJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('源安達快遞','YADEX');
INSERT INTO sys_express (express_name,express_code) VALUES ('遠成物流','YCWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('遠成快運','YCSY');
INSERT INTO sys_express (express_name,express_code) VALUES ('義達國際物流','YDH');
INSERT INTO sys_express (express_name,express_code) VALUES ('易達通','YDT');
INSERT INTO sys_express (express_name,express_code) VALUES ('原飛航物流','YFHEX');
INSERT INTO sys_express (express_name,express_code) VALUES ('亞風快遞','YFSD');
INSERT INTO sys_express (express_name,express_code) VALUES ('運通快遞','YTKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('億翔快遞','YXKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('運東西網(wǎng)','YUNDX');
INSERT INTO sys_express (express_name,express_code) VALUES ('壹米滴答','YMDD');
INSERT INTO sys_express (express_name,express_code) VALUES ('郵政國內(nèi)標快','YZBK');
INSERT INTO sys_express (express_name,express_code) VALUES ('一站通速運','YZTSY');
INSERT INTO sys_express (express_name,express_code) VALUES ('馭豐速運','YFSUYUN');
INSERT INTO sys_express (express_name,express_code) VALUES ('余氏東風','YSDF');
INSERT INTO sys_express (express_name,express_code) VALUES ('耀飛快遞','YF');
INSERT INTO sys_express (express_name,express_code) VALUES ('韻達快運','YDKY');
INSERT INTO sys_express (express_name,express_code) VALUES ('云路','YL');
INSERT INTO sys_express (express_name,express_code) VALUES ('增益快遞','ZENY');
INSERT INTO sys_express (express_name,express_code) VALUES ('匯強快遞','ZHQKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('眾通快遞','ZTE');
INSERT INTO sys_express (express_name,express_code) VALUES ('中鐵快運','ZTKY');
INSERT INTO sys_express (express_name,express_code) VALUES ('中鐵物流','ZTWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('鄭州速捷','SJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('中通快運','ZTOKY');
INSERT INTO sys_express (express_name,express_code) VALUES ('中郵快遞','ZYKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('中糧我買網(wǎng)','WM');
INSERT INTO sys_express (express_name,express_code) VALUES ('芝麻開門','ZMKM');
INSERT INTO sys_express (express_name,express_code) VALUES ('中驊物流','ZHWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('AAE全球?qū)＿f','AAE');
INSERT INTO sys_express (express_name,express_code) VALUES ('ACS雅仕快遞','ACS');
INSERT INTO sys_express (express_name,express_code) VALUES ('安圭拉郵政','ANGUILAYOU');
INSERT INTO sys_express (express_name,express_code) VALUES ('APAC','APAC');
INSERT INTO sys_express (express_name,express_code) VALUES ('Aramex','ARAMEX');
INSERT INTO sys_express (express_name,express_code) VALUES ('奧地利郵政','AT');
INSERT INTO sys_express (express_name,express_code) VALUES ('比利時郵政','BEL');
INSERT INTO sys_express (express_name,express_code) VALUES ('BHT快遞','BHT');
INSERT INTO sys_express (express_name,express_code) VALUES ('秘魯郵政','BILUYOUZHE');
INSERT INTO sys_express (express_name,express_code) VALUES ('巴西郵政','BR');
INSERT INTO sys_express (express_name,express_code) VALUES ('不丹郵政','BUDANYOUZH');
INSERT INTO sys_express (express_name,express_code) VALUES ('CDEK','CDEK');
INSERT INTO sys_express (express_name,express_code) VALUES ('加拿大郵政','CA');
INSERT INTO sys_express (express_name,express_code) VALUES ('遞必易國際物流','DBYWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('大道物流','DDWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('德國云快遞','DGYKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('到樂國際','DLGJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('DHL德國','DHL_DE');
INSERT INTO sys_express (express_name,express_code) VALUES ('DHL(英文版)','DHL_EN');
INSERT INTO sys_express (express_name,express_code) VALUES ('DHL全球','DHL_GLB');
INSERT INTO sys_express (express_name,express_code) VALUES ('丹麥郵政','DK');
INSERT INTO sys_express (express_name,express_code) VALUES ('DPD','DPD');
INSERT INTO sys_express (express_name,express_code) VALUES ('DPEX','DPEX');
INSERT INTO sys_express (express_name,express_code) VALUES ('遞四方速遞','D4PX');
INSERT INTO sys_express (express_name,express_code) VALUES ('EMS國際','EMSGJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('易客滿','EKM');
INSERT INTO sys_express (express_name,express_code) VALUES ('EPS(聯(lián)眾國際快運)','EPS');
INSERT INTO sys_express (express_name,express_code) VALUES ('EShipper','ESHIPPER');
INSERT INTO sys_express (express_name,express_code) VALUES ('豐程物流','FCWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('法翔速運','FX');
INSERT INTO sys_express (express_name,express_code) VALUES ('FQ','FQ');
INSERT INTO sys_express (express_name,express_code) VALUES ('芬蘭郵政','FLYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('方舟國際速遞','FZGJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('國際e郵寶','GJEYB');
INSERT INTO sys_express (express_name,express_code) VALUES ('國際郵政包裹','GJYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('GE2D','GE2D');
INSERT INTO sys_express (express_name,express_code) VALUES ('冠泰','GT');
INSERT INTO sys_express (express_name,express_code) VALUES ('GLS','GLS');
INSERT INTO sys_express (express_name,express_code) VALUES ('歐洲專線(郵政)','IOZYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('澳大利亞郵政','IADLYYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('阿爾巴尼亞郵政','IAEBNYYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('阿爾及利亞郵政','IAEJLYYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('阿富汗郵政','IAFHYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('安哥拉郵政','IAGLYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('埃及郵政','IAJYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('阿魯巴郵政','IALBYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('阿聯(lián)酋郵政','IALYYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('阿塞拜疆郵政','IASBJYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('博茨瓦納郵政','IBCWNYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('波多黎各郵政','IBDLGYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('冰島郵政','IBDYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('白俄羅斯郵政','IBELSYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('波黑郵政','IBHYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('保加利亞郵政','IBJLYYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('巴基斯坦郵政','IBJSTYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('黎巴嫩郵政','IBLNYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('波蘭郵政','IBOLYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('寶通達','IBTD');
INSERT INTO sys_express (express_name,express_code) VALUES ('貝郵寶','IBYB');
INSERT INTO sys_express (express_name,express_code) VALUES ('出口易','ICKY');
INSERT INTO sys_express (express_name,express_code) VALUES ('德國郵政','IDGYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('危地馬拉郵政','IWDMLYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('烏干達郵政','IWGDYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('烏克蘭EMS','IWKLEMS');
INSERT INTO sys_express (express_name,express_code) VALUES ('烏克蘭郵政','IWKLYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('烏拉圭郵政','IWLGYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('林克快遞','ILKKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('文萊郵政','IWLYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('新喀里多尼亞郵政','IXGLDNYYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('愛爾蘭郵政','IE');
INSERT INTO sys_express (express_name,express_code) VALUES ('夏浦物流','IXPWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('印度郵政','IYDYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('夏浦世紀','IXPSJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('厄瓜多爾郵政','IEGDEYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('俄羅斯郵政','IELSYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('飛特物流','IFTWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('瓜德羅普島郵政','IGDLPDYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('哥斯達黎加郵政','IGSDLJYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('韓國郵政','IHGYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('華翰物流','IHHWL');
INSERT INTO sys_express (express_name,express_code) VALUES ('互聯(lián)易','IHLY');
INSERT INTO sys_express (express_name,express_code) VALUES ('哈薩克斯坦郵政','IHSKSTYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('黑山郵政','IHSYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('津巴布韋郵政','IJBBWYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('吉爾吉斯斯坦郵政','IJEJSSTYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('捷克郵政','IJKYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('加納郵政','IJNYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('柬埔寨郵政','IJPZYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('克羅地亞郵政','IKNDYYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('肯尼亞郵政','IKNYYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('科特迪瓦EMS','IKTDWEMS');
INSERT INTO sys_express (express_name,express_code) VALUES ('羅馬尼亞郵政','ILMNYYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('摩爾多瓦郵政','IMEDWYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('馬耳他郵政','IMETYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('尼日利亞郵政','INRLYYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('塞爾維亞郵政','ISEWYYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('塞浦路斯郵政','ISPLSYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('烏茲別克斯坦郵政','IWZBKSTYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('西班牙郵政','IXBYYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('新加坡EMS','IXJPEMS');
INSERT INTO sys_express (express_name,express_code) VALUES ('希臘郵政','IXLYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('新西蘭郵政','IXXLYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('意大利郵政','IYDLYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('英國郵政','IYGYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('亞美尼亞郵政','IYMNYYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('也門郵政','IYMYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('智利郵政','IZLYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('日本郵政','JP');
INSERT INTO sys_express (express_name,express_code) VALUES ('今楓國際','JFGJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('極光轉(zhuǎn)運','JGZY');
INSERT INTO sys_express (express_name,express_code) VALUES ('吉祥郵轉(zhuǎn)運','JXYKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('嘉里國際','JLDT');
INSERT INTO sys_express (express_name,express_code) VALUES ('絕配國際速遞','JPKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('佳惠爾','SYJHE');
INSERT INTO sys_express (express_name,express_code) VALUES ('聯(lián)運通','LYT');
INSERT INTO sys_express (express_name,express_code) VALUES ('聯(lián)合快遞','LHKDS');
INSERT INTO sys_express (express_name,express_code) VALUES ('林道國際','SHLDHY');
INSERT INTO sys_express (express_name,express_code) VALUES ('荷蘭郵政','NL');
INSERT INTO sys_express (express_name,express_code) VALUES ('新順豐','NSF');
INSERT INTO sys_express (express_name,express_code) VALUES ('ONTRAC','ONTRAC');
INSERT INTO sys_express (express_name,express_code) VALUES ('OCS','OCS');
INSERT INTO sys_express (express_name,express_code) VALUES ('全球郵政','QQYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('POSTEIBE','POSTEIBE');
INSERT INTO sys_express (express_name,express_code) VALUES ('啪啪供應(yīng)鏈','PAPA');
INSERT INTO sys_express (express_name,express_code) VALUES ('秦遠海運','QYHY');
INSERT INTO sys_express (express_name,express_code) VALUES ('啟辰國際','VENUCIA');
INSERT INTO sys_express (express_name,express_code) VALUES ('瑞典郵政','RDSE');
INSERT INTO sys_express (express_name,express_code) VALUES ('SKYPOST','SKYPOST');
INSERT INTO sys_express (express_name,express_code) VALUES ('瑞士郵政','SWCH');
INSERT INTO sys_express (express_name,express_code) VALUES ('首達速運','SDSY');
INSERT INTO sys_express (express_name,express_code) VALUES ('穗空物流','SK');
INSERT INTO sys_express (express_name,express_code) VALUES ('首通快運','STONG');
INSERT INTO sys_express (express_name,express_code) VALUES ('申通快遞國際單','STO_INTL');
INSERT INTO sys_express (express_name,express_code) VALUES ('上海久易國際','JYSD');
INSERT INTO sys_express (express_name,express_code) VALUES ('泰國138','TAILAND138');
INSERT INTO sys_express (express_name,express_code) VALUES ('USPS美國郵政','USPS');
INSERT INTO sys_express (express_name,express_code) VALUES ('萬國郵政','UPU');
INSERT INTO sys_express (express_name,express_code) VALUES ('中越國際物流','VCTRANS');
INSERT INTO sys_express (express_name,express_code) VALUES ('星空國際','XKGJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('迅達國際','XD');
INSERT INTO sys_express (express_name,express_code) VALUES ('香港郵政','XGYZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('喜來快遞','XLKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('鑫世銳達','XSRD');
INSERT INTO sys_express (express_name,express_code) VALUES ('新元國際','XYGJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('ADLER雄鷹國際速遞','XYGJSD');
INSERT INTO sys_express (express_name,express_code) VALUES ('日本大和運輸(Yamato)','YAMA');
INSERT INTO sys_express (express_name,express_code) VALUES ('YODEL','YODEL');
INSERT INTO sys_express (express_name,express_code) VALUES ('一號線','YHXGJSD');
INSERT INTO sys_express (express_name,express_code) VALUES ('約旦郵政','YUEDANYOUZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('玥瑪速運','YMSY');
INSERT INTO sys_express (express_name,express_code) VALUES ('鷹運','YYSD');
INSERT INTO sys_express (express_name,express_code) VALUES ('易境達','YJD');
INSERT INTO sys_express (express_name,express_code) VALUES ('洋包裹','YBG');
INSERT INTO sys_express (express_name,express_code) VALUES ('友家速遞','YJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('AOL（澳通）','AOL');
INSERT INTO sys_express (express_name,express_code) VALUES ('BCWELT','BCWELT');
INSERT INTO sys_express (express_name,express_code) VALUES ('笨鳥國際','BN');
INSERT INTO sys_express (express_name,express_code) VALUES ('優(yōu)邦國際速運','UBONEX');
INSERT INTO sys_express (express_name,express_code) VALUES ('UEX','UEX');
INSERT INTO sys_express (express_name,express_code) VALUES ('韻達國際','YDGJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('愛購轉(zhuǎn)運','ZY_AG');
INSERT INTO sys_express (express_name,express_code) VALUES ('愛歐洲','ZY_AOZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('澳世速遞','ZY_AUSE');
INSERT INTO sys_express (express_name,express_code) VALUES ('AXO','ZY_AXO');
INSERT INTO sys_express (express_name,express_code) VALUES ('貝海速遞','ZY_BH');
INSERT INTO sys_express (express_name,express_code) VALUES ('蜜蜂速遞','ZY_BEE');
INSERT INTO sys_express (express_name,express_code) VALUES ('百利快遞','ZY_BL');
INSERT INTO sys_express (express_name,express_code) VALUES ('斑馬物流','ZY_BM');
INSERT INTO sys_express (express_name,express_code) VALUES ('百通物流','ZY_BT');
INSERT INTO sys_express (express_name,express_code) VALUES ('策馬轉(zhuǎn)運','ZY_CM');
INSERT INTO sys_express (express_name,express_code) VALUES ('宜送轉(zhuǎn)運','ZY_ESONG');
INSERT INTO sys_express (express_name,express_code) VALUES ('飛碟快遞','ZY_FD');
INSERT INTO sys_express (express_name,express_code) VALUES ('飛鴿快遞','ZY_FG');
INSERT INTO sys_express (express_name,express_code) VALUES ('風行快遞','ZY_FX');
INSERT INTO sys_express (express_name,express_code) VALUES ('風行速遞','ZY_FXSD');
INSERT INTO sys_express (express_name,express_code) VALUES ('飛洋快遞','ZY_FY');
INSERT INTO sys_express (express_name,express_code) VALUES ('皓晨快遞','ZY_HC');
INSERT INTO sys_express (express_name,express_code) VALUES ('海悅速遞','ZY_HYSD');
INSERT INTO sys_express (express_name,express_code) VALUES ('君安快遞','ZY_JA');
INSERT INTO sys_express (express_name,express_code) VALUES ('時代轉(zhuǎn)運','ZY_JD');
INSERT INTO sys_express (express_name,express_code) VALUES ('駿達快遞','ZY_JDKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('駿達轉(zhuǎn)運','ZY_JDZY');
INSERT INTO sys_express (express_name,express_code) VALUES ('久禾快遞','ZY_JH');
INSERT INTO sys_express (express_name,express_code) VALUES ('金海淘','ZY_JHT');
INSERT INTO sys_express (express_name,express_code) VALUES ('聯(lián)邦轉(zhuǎn)運FedRoad','ZY_LBZY');
INSERT INTO sys_express (express_name,express_code) VALUES ('龍象快遞','ZY_LX');
INSERT INTO sys_express (express_name,express_code) VALUES ('美國轉(zhuǎn)運','ZY_MGZY');
INSERT INTO sys_express (express_name,express_code) VALUES ('美速通','ZY_MST');
INSERT INTO sys_express (express_name,express_code) VALUES ('美西轉(zhuǎn)運','ZY_MXZY');
INSERT INTO sys_express (express_name,express_code) VALUES ('QQ-EX','ZY_QQEX');
INSERT INTO sys_express (express_name,express_code) VALUES ('瑞天快遞','ZY_RT');
INSERT INTO sys_express (express_name,express_code) VALUES ('瑞天速遞','ZY_RTSD');
INSERT INTO sys_express (express_name,express_code) VALUES ('速達快遞','ZY_SDKD');
INSERT INTO sys_express (express_name,express_code) VALUES ('四方轉(zhuǎn)運','ZY_SFZY');
INSERT INTO sys_express (express_name,express_code) VALUES ('上騰快遞','ZY_ST');
INSERT INTO sys_express (express_name,express_code) VALUES ('天際快遞','ZY_TJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('天馬轉(zhuǎn)運','ZY_TM');
INSERT INTO sys_express (express_name,express_code) VALUES ('滕畔峋快遞','ZY_TN');
INSERT INTO sys_express (express_name,express_code) VALUES ('太平洋快遞','ZY_TPY');
INSERT INTO sys_express (express_name,express_code) VALUES ('唐三藏轉(zhuǎn)運','ZY_TSZ');
INSERT INTO sys_express (express_name,express_code) VALUES ('TWC轉(zhuǎn)運世界','ZY_TWC');
INSERT INTO sys_express (express_name,express_code) VALUES ('潤東國際快線','ZY_RDGJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('同心快遞','ZY_TX');
INSERT INTO sys_express (express_name,express_code) VALUES ('天翼快遞','ZY_TY');
INSERT INTO sys_express (express_name,express_code) VALUES ('德國海淘之家','ZY_DGHT');
INSERT INTO sys_express (express_name,express_code) VALUES ('德運網(wǎng)','ZY_DYW');
INSERT INTO sys_express (express_name,express_code) VALUES ('文達國際DCS','ZY_WDCS');
INSERT INTO sys_express (express_name,express_code) VALUES ('同舟快遞','ZY_TZH');
INSERT INTO sys_express (express_name,express_code) VALUES ('UCS合眾快遞','ZY_UCS');
INSERT INTO sys_express (express_name,express_code) VALUES ('星辰快遞','ZY_XC');
INSERT INTO sys_express (express_name,express_code) VALUES ('先鋒快遞','ZY_XF');
INSERT INTO sys_express (express_name,express_code) VALUES ('西郵寄','ZY_XIYJ');
INSERT INTO sys_express (express_name,express_code) VALUES ('云騎快遞','ZY_YQ');
INSERT INTO sys_express (express_name,express_code) VALUES ('優(yōu)晟速遞','ZY_YSSD');
INSERT INTO sys_express (express_name,express_code) VALUES ('運淘美國','ZY_YTUSA');
INSERT INTO sys_express (express_name,express_code) VALUES ('至誠速遞','ZY_ZCSD');
INSERT INTO sys_express (express_name,express_code) VALUES ('增速海淘','ZYZOOM');
INSERT INTO sys_express (express_name,express_code) VALUES ('中馳物流','ZH');
INSERT INTO sys_express (express_name,express_code) VALUES ('中歐快運','ZO');
INSERT INTO sys_express (express_name,express_code) VALUES ('準實快運','ZSKY');
INSERT INTO sys_express (express_name,express_code) VALUES ('中外速運','ZWSY');
INSERT INTO sys_express (express_name,express_code) VALUES ('鄭州建華','ZZJH');

?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者

人面猴
序言：七十年代末拴清，一起剝皮案震驚了整個濱河市，隨后出現(xiàn)的幾起案子娄周，更是在濱河造成了極大的恐慌沪停，老刑警劉巖木张，帶你破解...
沈念sama閱讀 218,755評論 6贊 507
死咒
序言：濱河連續(xù)發(fā)生了三起死亡事件，死亡現(xiàn)場離奇詭異泻轰，居然都是意外死亡浮声，警方通過查閱死者的電腦和手機旋奢，發(fā)現(xiàn)死者居然都...
沈念sama閱讀 93,305評論 3贊 395
救了他兩次的神仙讓他今天三更去死
文/潘曉璐我一進店門至朗，熙熙樓的掌柜王于貴愁眉苦臉地迎上來，“玉大人矗钟，你說我怎么就攤上這事吨艇。” “怎么了冯吓？”我有些...
開封第一講書人閱讀 165,138評論 0贊 355
道士緝兇錄：失蹤的賣姜人
文/不壞的土叔我叫張陵组贺，是天一觀的道長祖娘。經(jīng)常有香客問我贿条，道長增热，這世上最難降的妖魔是什么？我笑而不...
開封第一講書人閱讀 58,791評論 1贊 295
?港島之戀（遺憾婚禮）
正文為了忘掉前任公黑，我火速辦了婚禮凡蚜，結(jié)果婚禮上吭从，老公的妹妹穿的比我還像新娘涩金。我一直安慰自己，他們只是感情好副渴，可當我...
茶點故事閱讀 67,794評論 6贊 392
惡毒庶女頂嫁案：這布局不是一般人想出來的
文/花漫我一把揭開白布煮剧。她就那樣靜靜地躺著，像睡著了一般佑颇。火紅的嫁衣襯著肌膚如雪漩符。梳的紋絲不亂的頭發(fā)上驱还，一...
開封第一講書人閱讀 51,631評論 1贊 305
城市分裂傳說
那天议蟆，我揣著相機與錄音，去河邊找鬼舆逃。笑死戳粒，一個胖子當著我的面吹牛蔚约，可吹牛的內(nèi)容都是我干的。我是一名探鬼主播砸抛，決...
沈念sama閱讀 40,362評論 3贊 418
雙鴛鴦連環(huán)套：你想象不到人心有多黑
文/蒼蘭香墨我猛地睜開眼直焙，長吁一口氣：“原來是場噩夢啊……” “哼砂轻！你這毒婦竟也來了搔涝？” 一聲冷哼從身側(cè)響起，我...
開封第一講書人閱讀 39,264評論 0贊 276
萬榮殺人案實錄
序言：老撾萬榮一對情侶失蹤，失蹤者是張志新（化名）和其女友劉穎抒痒，沒想到半個月后，有當?shù)厝嗽跇淞掷锇l(fā)現(xiàn)了一具尸體颁独，經(jīng)...
沈念sama閱讀 45,724評論 1贊 315
?護林員之死
正文獨居荒郊野嶺守林人離奇死亡伪冰，尸身上長有42處帶血的膿包…… 初始之章·張勛以下內(nèi)容為張勛視角年9月15日...
茶點故事閱讀 37,900評論 3贊 336
?白月光啟示錄
正文我和宋清朗相戀三年贮聂，在試婚紗的時候發(fā)現(xiàn)自己被綠了吓懈。大學時的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片。...
茶點故事閱讀 40,040評論 1贊 350
活死人
序言：一個原本活蹦亂跳的男人離奇死亡，死狀恐怖甘穿，靈堂內(nèi)的尸體忽然破棺而出温兼，到底是詐尸還是另有隱情，我是刑警寧澤缸榛，帶...
沈念sama閱讀 35,742評論 5贊 346
?日本核電站爆炸內(nèi)幕
正文年R本政府宣布，位于F島的核電站敦腔，受9級特大地震影響恨溜，放射性物質(zhì)發(fā)生泄漏。R本人自食惡果不足惜判族，卻給世界環(huán)境...
茶點故事閱讀 41,364評論 3贊 330
男人毒藥：我在死后第九天來索命
文/蒙蒙一形帮、第九天我趴在偏房一處隱蔽的房頂上張望。院中可真熱鬧界斜，春花似錦合冀、人聲如沸君躺。這莊子的主人今日做“春日...
開封第一講書人閱讀 31,944評論 0贊 22
一樁弒父案，背后竟有這般陰謀
文/蒼蘭香墨我抬頭看了看天上的太陽治宣。三九已至砌滞，卻和暖如春贝润，著一層夾襖步出監(jiān)牢的瞬間，已是汗流浹背华畏。一陣腳步聲響...
開封第一講書人閱讀 33,060評論 1贊 270
情欲美人皮
我被黑心中介騙來泰國打工亡笑，沒想到剛下飛機就差點兒被人妖公主榨干…… 1. 我叫王不留横朋，地道東北人琴锭。一個月前我還...
沈念sama閱讀 48,247評論 3贊 371
代替公主和親
正文我出身青樓决帖，卻偏偏與公主長得像，于是被迫代替她去往敵國和親扁远。傳聞我的和親對象是個殘疾皇子，可洞房花燭夜當晚...
茶點故事閱讀 44,979評論 2贊 355

史上最全的快遞公司編碼大全（附sql）

推薦閱讀更多精彩內(nèi)容