美文网首页
史上最全的快递公司编码大全(附sql)

史上最全的快递公司编码大全(附sql)

作者: 白纸画 | 来源:发表于2021-01-14 15:47 被阅读0次
    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 '启用状态',
        gmt_create    datetime               null comment '创建时间',
        gmt_modify    datetime               null comment '修改时间',
        create_by     bigint                 null comment '创建人',
        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 ('优速快递','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联邦(国内件)','FEDEX');
    INSERT INTO sys_express (express_name,express_code) VALUES ('FEDEX联邦(国际件)','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 ('长沙创一','CSCY');
    INSERT INTO sys_express (express_name,express_code) VALUES ('成都善途速运','CDSTKY');
    INSERT INTO sys_express (express_name,express_code) VALUES ('联合运通','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 ('快服务','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 ('鸿桥供应链','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 ('环球速运','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 ('九曳供应链','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 ('联昊通速递','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 ('优联吉运','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 ('希优特','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 ('运东西网','YUNDX');
    INSERT INTO sys_express (express_name,express_code) VALUES ('壹米滴答','YMDD');
    INSERT INTO sys_express (express_name,express_code) VALUES ('邮政国内标快','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 ('中粮我买网','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全球专递','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(联众国际快运)','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 ('阿联酋邮政','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 ('互联易','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 ('极光转运','JGZY');
    INSERT INTO sys_express (express_name,express_code) VALUES ('吉祥邮转运','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 ('联运通','LYT');
    INSERT INTO sys_express (express_name,express_code) VALUES ('联合快递','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 ('啪啪供应链','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 ('优邦国际速运','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 ('爱购转运','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 ('策马转运','ZY_CM');
    INSERT INTO sys_express (express_name,express_code) VALUES ('宜送转运','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 ('时代转运','ZY_JD');
    INSERT INTO sys_express (express_name,express_code) VALUES ('骏达快递','ZY_JDKD');
    INSERT INTO sys_express (express_name,express_code) VALUES ('骏达转运','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 ('联邦转运FedRoad','ZY_LBZY');
    INSERT INTO sys_express (express_name,express_code) VALUES ('龙象快递','ZY_LX');
    INSERT INTO sys_express (express_name,express_code) VALUES ('美国转运','ZY_MGZY');
    INSERT INTO sys_express (express_name,express_code) VALUES ('美速通','ZY_MST');
    INSERT INTO sys_express (express_name,express_code) VALUES ('美西转运','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 ('四方转运','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 ('天马转运','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 ('唐三藏转运','ZY_TSZ');
    INSERT INTO sys_express (express_name,express_code) VALUES ('TWC转运世界','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 ('德运网','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 ('优晟速递','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');
    

    相关文章

      网友评论

          本文标题:史上最全的快递公司编码大全(附sql)

          本文链接:https://www.haomeiwen.com/subject/ehuvaktx.html