史上最全的快递公司编码大全(附sql)
2021-01-14 本文已影响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');