數據庫中部分數據如下:

/*Navicat Premium Data TransferSource Server : yfy的linuxSource Server Type : MySQLSource Server Version : 50644Source Host : 39.105.67.182Source Database : p19014Target Server Type : MySQLTarget Server Version : 50644File Encoding : utf-8Date: 09/07/2019 15:12:33 PM */SET NAMES utf8; SET FOREIGN_KEY_CHECKS = 0;-- ---------------------------- -- Table structure for `logistics_company` -- ---------------------------- DROP TABLE IF EXISTS `logistics_company`; CREATE TABLE `logistics_company` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',`name` varchar(20) DEFAULT NULL COMMENT '快遞公司名',`type` varchar(20) DEFAULT NULL COMMENT '快遞公司編號',`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間',PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8mb4 COMMENT='快遞公司表';-- ---------------------------- -- Records of `logistics_company` -- ---------------------------- BEGIN; INSERT INTO `logistics_company` VALUES ('1', 'AAE', 'AAEWEB', '2019-09-07 12:06:32'), ('2', '安訊物流', 'ANXL', '2019-09-07 12:06:48'), ('3', '安捷物流', 'AJWL', '2019-09-07 12:07:09'), ('4', '安世通快遞', 'ASTEXPRESS', '2019-09-07 12:07:40'), ('5', '澳多多國際速遞', 'ADODOXOM', '2019-09-07 12:08:13'), ('6', '安達速遞', 'ADAPOST', '2019-09-07 12:08:41'), ('7', '澳洲邁速快遞', 'MAXEEDEXPRESS', '2019-09-07 12:09:08'), ('8', 'Aramex', 'ARAMEX', '2019-09-07 12:09:21'), ('9', 'DHL國內件', 'DHL', '2019-09-07 12:09:32'), ('10', 'DPEX', 'DPEX', '2019-09-07 12:09:39'), ('11', 'D速', 'DEXP', '2019-09-07 12:09:50'), ('12', 'EMS', 'EMS', '2019-09-07 12:09:57'), ('13', 'EWE', 'EWE', '2019-09-07 12:10:05'), ('14', 'FedEx', 'FEDEX', '2019-09-07 12:10:15'), ('15', 'FedEx國際', 'FEDEXIN', '2019-09-07 12:10:29'), ('16', 'PCA', 'PCA', '2019-09-07 12:10:41'), ('17', 'TNT', 'TNT', '2019-09-07 12:10:48'), ('18', 'UPS', 'UPS', '2019-09-07 12:10:57'), ('19', '安捷快遞', 'ANJELEX', '2019-09-07 12:11:17'), ('20', '安能', 'ANE', '2019-09-07 12:11:28'), ('21', '安能快遞', 'ANEEX', '2019-09-07 12:11:38'), ('22', '安信達', 'ANXINDA', '2019-09-07 12:11:53'), ('23', '百福東方', 'EES', '2019-09-07 12:12:08'), ('24', '百世快遞', 'HTKY', '2019-09-07 12:12:26'), ('25', '百世快運', 'BSKY', '2019-09-07 14:22:18'), ('26', '程光', 'FLYWAYEX', '2019-09-07 14:30:02'), ('27', '大田', 'DTW', '2019-09-07 14:30:56'), ('28', '德邦', 'DEPPON', '2019-09-07 14:31:12'), ('29', '飛洋', 'GCE', '2019-09-07 14:32:35'), ('30', '鳳凰', 'PHOENIXEXP', '2019-09-07 14:32:46'), ('31', '富騰達', 'FTD', '2019-09-07 14:33:01'), ('32', '共速達', 'GSD', '2019-09-07 14:33:12'), ('33', '國通', 'GTO', '2019-09-07 14:33:21'), ('34', '黑狗', 'BLACKDOG', '2019-09-07 14:33:30'), ('35', '恒路', 'HENGLU', '2019-09-07 14:33:46'), ('36', '鴻遠', 'HYE', '2019-09-07 14:34:14'), ('37', '華企', 'HQKY', '2019-09-07 14:34:32'), ('38', '急先達', 'JOUST', '2019-09-07 14:34:52'), ('39', '加運美', 'TMS', '2019-09-07 14:35:02'), ('40', '佳吉', 'JIAJI', '2019-09-07 14:35:16'), ('41', '佳怡', 'JIAYI', '2019-09-07 14:35:26'), ('42', '嘉里物流', 'KERRY', '2019-09-07 14:35:40'), ('43', '錦程快遞', 'HREX', '2019-09-07 14:36:06'), ('44', '晉越', 'PEWKEE', '2019-09-07 14:36:22'), ('45', '京東', 'JD', '2019-09-07 14:36:57'), ('46', '京廣', 'KKE', '2019-09-07 14:37:06'), ('47', '九曳', 'JIUYESCM', '2019-09-07 14:37:20'), ('48', '跨越蘇運', 'KYEXPRESS', '2019-09-07 14:37:40'), ('49', '快捷', 'FASTEXPRESS', '2019-09-07 14:38:06'), ('50', '藍天', 'BLUESKY', '2019-09-07 14:38:16'), ('51', '聯昊通', 'LTS', '2019-09-07 14:38:32'), ('52', '中通快運', 'ZTO56', '2019-09-07 14:42:08'), ('53', '壹米滴答', 'YIMIDIDA', '2019-09-07 14:42:32'), ('54', '日日順物流', 'RRS', '2019-09-07 14:42:42'), ('55', '宇鑫物流', 'YXWL', '2019-09-07 14:42:56'), ('56', '東駿快捷', 'DJ56', '2019-09-07 14:43:18'), ('57', '聯邦快遞國際', 'FEDEX_GJ', '2019-09-07 14:44:18'), ('58', '澳郵專線(澳郵中國快運)', 'AYCA', '2019-09-07 14:45:10'), ('59', '城市100', 'CITY100', '2019-09-07 14:45:22'), ('60', '遞四方速遞', 'D4PX', '2019-09-07 14:45:42'), ('61', '廣通', 'GTSD', '2019-09-07 14:45:49'), ('62', '好來運快遞', 'HYLSD', '2019-09-07 14:46:07'), ('63', '捷特快遞', 'JTKD', '2019-09-07 14:46:23'), ('64', '民邦快遞', 'MB', '2019-09-07 14:46:34'), ('65', '明亮物流', 'MLWL', '2019-09-07 14:46:49'), ('66', '泛捷快遞', 'PANEX', '2019-09-07 14:47:13'), ('67', '全信通', 'QXT', '2019-09-07 14:47:24'), ('68', '賽澳遞', 'SAD', '2019-09-07 14:47:34'), ('69', '上大物流', 'SDWL', '2019-09-07 14:47:42'), ('70', '速騰快遞', 'STWL', '2019-09-07 14:47:53'), ('71', '萬家康', 'WJK', '2019-09-07 14:48:00'), ('72', '增益快遞', 'ZENY', '2019-09-07 14:48:29'), ('73', '河馬動力', 'HEMA', '2019-09-07 14:48:42'), ('74', '民航', 'CAE', '2019-09-07 14:49:22'), ('75', '澳天速運', 'AOTSD', '2019-09-07 14:49:49'), ('76', '安鮮達', 'EXFRESH', '2019-09-07 14:50:05'), ('77', 'ANTS', 'ANTS', '2019-09-07 14:50:17'), ('78', '愛拜物流', 'IBUY8', '2019-09-07 14:50:39'), ('79', 'Aplus物流', 'APLUSEX', '2019-09-07 14:50:51'), ('80', '澳世速遞', 'AUSEXPRESS', '2019-09-07 14:51:05'), ('81', '昂威物流', 'ONWAY', '2019-09-07 14:51:25'), ('82', '能達', 'ND56', '2019-09-07 14:51:36'), ('83', 'DHL國際件', 'DHL_EN', '2019-09-07 14:51:50'), ('84', '平安快遞', 'EPSPOST', '2019-09-07 14:52:02'), ('85', '秦遠物流', 'CHINZ56', '2019-09-07 14:52:22'), ('86', '全晨', 'QCKD', '2019-09-07 14:52:34'), ('87', '全峰', 'QFKD', '2019-09-07 14:52:43'), ('88', '全一', 'APEX', '2019-09-07 14:52:54'), ('89', '如風達', 'RFD', '2019-09-07 14:53:02'), ('90', '三態', 'SFC', '2019-09-07 14:53:18'), ('91', '申通', 'STO', '2019-09-07 14:53:29'), ('92', '盛豐', 'SFWL', '2019-09-07 14:53:52'), ('93', '盛輝', 'SHENGHUI', '2019-09-07 14:54:05'), ('94', '順達快遞', 'SDEX', '2019-09-07 14:54:13'), ('95', '順豐', 'SFEXPRESS', '2019-09-07 14:54:44'), ('96', '蘇寧', 'SUNING', '2019-09-07 14:54:55'), ('97', '速爾', 'SURE', '2019-09-07 14:55:03'), ('98', '天地華宇', 'HOAU', '2019-09-07 14:55:15'), ('99', '天天', 'TIKDEX', '2019-09-07 14:55:24'), ('100', '萬庚', 'VANGEN', '2019-09-07 14:55:37'), ('101', '萬家物流', 'WANJIA', '2019-09-07 14:55:47'), ('102', '萬象', 'EWINSHINE', '2019-09-07 14:56:00'), ('103', '文捷航空', 'GZWENJIE', '2019-09-07 14:56:21'), ('104', '新邦', 'XBWL', '2019-09-07 14:56:49'), ('105', '信豐', 'XFEXPRESS', '2019-09-07 14:56:59'), ('106', '亞風', 'BROADASIA', '2019-09-07 14:57:18'), ('107', '宜送', 'YIEXPRESS', '2019-09-07 14:57:39'), ('108', '易達通', 'QEXPRESS', '2019-09-07 14:57:57'), ('109', '易通達', 'ETD', '2019-09-07 14:58:06'), ('110', '優速', 'UC56', '2019-09-07 14:58:25'), ('111', '郵政包裹', 'CHINAPOST', '2019-09-07 14:58:34'), ('112', '原飛航', 'YEHEX', '2019-09-07 14:58:53'), ('113', '圓通', 'YTO', '2019-09-07 14:59:01'), ('114', '源安達', 'YADEX', '2019-09-07 14:59:16'), ('115', '遠成', 'YCGWL', '2019-09-07 14:59:27'), ('116', '越豐', 'YFEXPRESS', '2019-09-07 14:59:40'), ('117', '運通', 'YTEXPRESS', '2019-09-07 14:59:50'), ('118', '韻達', 'YUNDA', '2019-09-07 14:59:58'), ('119', '宅急送', 'ZJS', '2019-09-07 15:00:09'), ('120', '芝麻開門', 'ZMKMEX', '2019-09-07 15:00:21'), ('121', '中國東方', 'COE', '2019-09-07 15:00:32'), ('122', '中鐵快運', 'CRE', '2019-09-07 15:00:44'), ('123', '中鐵物流', 'ZTKY', '2019-09-07 15:00:53'), ('124', '中通', 'ZTO', '2019-09-07 15:00:59'), ('125', '龍邦', 'LBEX', '2019-09-07 15:01:07'), ('126', '中郵', 'CNPL', '2019-09-07 15:01:15'), ('127', '品駿快遞', 'PJKD', '2019-09-07 15:01:27'), ('128', '匯通快遞', 'HTKY', '2019-09-07 15:01:41'), ('129', '郵政國際包裹', 'INTMAIL', '2019-09-07 15:01:52'), ('130', '聯邦快遞', 'FEDEX', '2019-09-07 15:02:02'), ('131', '配思航宇', 'PEISI', '2019-09-07 15:02:16'), ('132', '八達通', 'BDT', '2019-09-07 15:02:27'), ('133', '城際快遞', 'CJKD', '2019-09-07 15:03:59'), ('134', '飛康達', 'FKD', '2019-09-07 15:04:12'), ('135', '環球速運', 'HQSY', '2019-09-07 15:04:21'), ('136', '捷安達', 'JAD', '2019-09-07 15:04:32'), ('137', '景光物流', 'JGWL', '2019-09-07 15:04:48'), ('138', '美快', 'MK', '2019-09-07 15:04:59'), ('139', '平安達騰飛快遞', 'PADTF', '2019-09-07 15:05:14'), ('140', '全日通快遞', 'QRT', '2019-09-07 15:05:23'), ('141', '瑞風速遞', 'RFEX', '2019-09-07 15:05:36'), ('142', '圣安物流', 'SAWL', '2019-09-07 15:05:50'), ('143', '速通物流', 'ST', '2019-09-07 15:05:58'), ('144', '速必達物流', 'SUBIDA', '2019-09-07 15:06:11'), ('145', '新杰物流', 'XJ', '2019-09-07 15:06:23'), ('146', '中郵物流', 'ZYWL', '2019-09-07 15:06:33'), ('147', '澳通速遞', 'AOL', '2019-09-07 15:06:43'), ('148', '歐亞專線', 'EUASIA', '2019-09-07 15:06:52'); COMMIT;SET FOREIGN_KEY_CHECKS = 1;

?

總結

以上是生活随笔為你收集整理的全国快递物流查询公司mysql数据库语句的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。