From b41a086e968a5cc3159bade53a0995e4b63d363e Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期六, 19 九月 2026 10:26:29 +0800
Subject: [PATCH] feat(货运): 同名企业口径SQL新增企业明细导出查询(546家/含改名标记)+导出说明
---
docs/工作日结/工作日结_2026-09-19.md | 10 +++
docs/生成汇总大表/同名企业_1-8月累计对比_2026-09-19.sql | 97 ++++++++++++++++++++++++++++++++
docs/功能测试报告/功能测试报告_同名企业1-8月累计货运量与周转量SQL_2026-09-19.md | 26 ++++++++
3 files changed, 129 insertions(+), 4 deletions(-)
diff --git "a/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\345\220\214\345\220\215\344\274\201\344\270\2321-8\346\234\210\347\264\257\350\256\241\350\264\247\350\277\220\351\207\217\344\270\216\345\221\250\350\275\254\351\207\217SQL_2026-09-19.md" "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\345\220\214\345\220\215\344\274\201\344\270\2321-8\346\234\210\347\264\257\350\256\241\350\264\247\350\277\220\351\207\217\344\270\216\345\221\250\350\275\254\351\207\217SQL_2026-09-19.md"
index 976b400..26ecb6f 100644
--- "a/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\345\220\214\345\220\215\344\274\201\344\270\2321-8\346\234\210\347\264\257\350\256\241\350\264\247\350\277\220\351\207\217\344\270\216\345\221\250\350\275\254\351\207\217SQL_2026-09-19.md"
+++ "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\345\220\214\345\220\215\344\274\201\344\270\2321-8\346\234\210\347\264\257\350\256\241\350\264\247\350\277\220\351\207\217\344\270\216\345\221\250\350\275\254\351\207\217SQL_2026-09-19.md"
@@ -59,9 +59,31 @@
鍒嗗競宸炴煡璇㈢敤 `MAX(CASE WHEN report_period >= '2026-01' ...)` 鍙� 2026 骞寸殑鍦板尯浠ｇ爜锛�
浼佷笟璺ㄥ競杩佺Щ鏃舵寜 2026 骞村綊灞炵粺璁★紝瀹炴祴鏈彂鐜板奖鍝嶏紙鍚屽悕浼佷笟涓ゅ湴骞跺瓨鐨勬儏鍐垫棤锛夈��
-## 浜斻�佺粨璁�
+## 浜斻�佽ˉ鍏咃細浼佷笟鏄庣粏瀵煎嚭锛�2026-09-19 杩藉姞锛�
-6 鏉℃煡璇㈡暣鑴氭湰鎵ц閫氳繃锛�12 鏉＄敤渚嬶紙8 姝ｅ悜 / 2 璐熷悜 / 2 杈圭晫锛夊叏閮ㄩ�氳繃銆�
+鐢ㄦ埛瑕佹眰鎶婁紒涓氭槑缁嗕篃瀵煎嚭鏉ワ紝鑴氭湰杩藉姞涓ゆ潯鏌ヨ锛�
+
+- **鏌ヨ 7 浼佷笟鏄庣粏瀵煎嚭**锛氬尮閰嶉敭鏀圭敤 `unified_credit_code`锛堢粺涓�绀句細淇＄敤浠ｇ爜锛夛紝鍏� **546 瀹�**锛�
+ 姣旀煡璇� 2 澶氳鐩� 1 瀹舵敼鍚嶄紒涓氾紙`91420112558443820B`锛�2025-01~2025-09 鍙�
+ 銆屾箹鍖椾笁宄″瘜鐑ㄧ豢鐢典緵搴旈摼鏈夐檺鍏徃銆嶏紝2025-10 璧峰彨銆屾箹鍖楅暱宄″瘜鐑ㄧ豢鐢典緵搴旈摼鏈夐檺鍏徃銆嶏級銆�
+ 杈撳嚭 14 鍒楋細缁熶竴绀句細淇＄敤浠ｇ爜銆佷紒涓氬悕绉帮紙2026 骞村悕绉帮級銆佸悕绉�2025銆佹槸鍚︽敼鍚嶃�佸競宸炪�佸湴鍖轰唬鐮併��
+ 璐ц繍閲忎袱骞村��/澧炲噺/鍚屾瘮銆佸懆杞噺涓ゅ勾鍊�/澧炲噺/鍚屾瘮锛屾寜 2026 骞磋揣杩愰噺闄嶅簭銆�
+- **鏌ヨ 8 鍚堣瀵规�绘暟**锛�546 瀹跺彛寰� 2025 骞� 1-8 鏈堣揣杩愰噺 30162.99 涓囧惃 / 鍛ㄨ浆閲� 4637038.58 涓囧惃鍏噷锛�
+ 2026 骞� 1-8 鏈堣揣杩愰噺 27764.88 涓囧惃 / 鍛ㄨ浆閲� 4392984.81 涓囧惃鍏噷銆�
+- 鑴氭湰鍐呴檮涓夌瀵煎嚭鏂瑰紡锛氬懡浠よ `--batch --raw` 瀵� tsv銆丯avicat/Workbench 瀵� xlsx銆乣SELECT ... INTO OUTFILE`銆�
+
+琛ュ厖娴嬭瘯锛�
+
+| 缂栧彿 | 绫诲瀷 | 鐢ㄤ緥 | 棰勬湡 | 瀹為檯 | 缁撹 |
+| --- | --- | --- | --- | --- | --- |
+| T13 | 姝ｅ悜 | 鏌ヨ 7 鏄庣粏琛屾暟 | 546 琛� | 546 琛岋紝鍏朵腑 1 琛� `鏄惁鏀瑰悕='鏄�'` | 閫氳繃 |
+| T14 | 姝ｅ悜 | 鏌ヨ 7 鏄庣粏姹傚拰 = 鏌ヨ 8 鍚堣 | 涓�鑷达紙鍏佽鍥涜垗浜斿叆灏惧樊锛� | 鏄庣粏閫愯鍥涜垗浜斿叆鍚庢眰鍜� 30163.10 / 27764.86 / 4637038.56 / 4392984.78锛屼笌鍚堣宸� 0.01~0.02锛屽睘姝ｅ父灏惧樊 | 閫氳繃 |
+| T15 | 姝ｅ悜 | 鍛戒护琛屽鍑猴紙鏂瑰紡涓�锛� | 鐢熸垚 UTF-8 鐨� tsv锛屽惈 546 琛屾暟鎹� | 89046 瀛楄妭銆�546 琛屾暟鎹�佷腑鏂囧垪鍚嶄笌浼佷笟鍚嶆甯� | 閫氳繃 |
+| T16 | 杈圭晫 | Excel 鐩存帴鍙屽嚮 tsv | 瀛樺湪涓枃涔辩爜椋庨櫓 | 鏂囦欢涓� UTF-8 鏃� BOM锛屽凡鍦ㄨ剼鏈唴娉ㄦ槑鏀圭敤銆屾暟鎹� 鈫� 浠庢枃鏈�/CSV銆嶅鍏ユ垨鐩存帴瀵� xlsx | 閫氳繃 |
+| T17 | 杈圭晫 | 鏄庣粏涓悓姣旈櫎闆� | 鍩烘湡涓� 0 鏃朵笉鎶ラ敊 | `NULLIF(...,0)` 淇濇姢锛岃繑鍥炵┖鍊� | 閫氳繃 |
+## 鍏�佺粨璁�
+
+8 鏉℃煡璇㈡暣鑴氭湰鎵ц閫氳繃锛�17 鏉＄敤渚嬶紙11 姝ｅ悜 / 2 璐熷悜 / 4 杈圭晫锛夊叏閮ㄩ�氳繃銆�
**鍚屽悕浼佷笟鍙ｅ緞锛�545 瀹讹級1-8 鏈堢疮璁＄粨鏋滐細**
diff --git "a/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-19.md" "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-19.md"
index a7a7385..6546f6b 100644
--- "a/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-19.md"
+++ "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-19.md"
@@ -54,6 +54,14 @@
鍚屽悕鍙ｅ緞鐨� 2026 骞寸疮璁℃暟涓庣櫧澶╀氦浠樹欢鍏ㄧ渷琛岋紙27752.6820 涓囧惃 / 4389882.0468 涓囧惃鍏噷锛夊畬鍏ㄤ竴鑷达紝涓ゆ潯閾捐矾浜掕瘉閫氳繃銆�
鍏ㄩ噺涓庡悓鍚嶅彛寰勭殑宸涔熷凡绠楁竻锛�2026 骞存柊杩� 91 瀹讹紙+3647.14 涓囧惃 / +537279.73 涓囧惃鍏噷锛夛紝
2025 骞撮��鍑� 119 瀹讹紙鈭�3841.31 涓囧惃 / 鈭�467178.48 涓囧惃鍏噷锛夈��
+琛ュ厖锛堝綋鏃ヨ拷鍔狅級锛氱敤鎴锋帴鐫�瑕併�屼紒涓氭槑缁嗕篃瀵煎嚭鏉ャ�嶏紝鑴氭湰杩藉姞 **鏌ヨ 7 浼佷笟鏄庣粏瀵煎嚭** 涓� **鏌ヨ 8 鍚堣瀵规�绘暟**銆�
+
+- 鏌ヨ 7 鐨勫尮閰嶉敭鏀圭敤 `unified_credit_code`锛岃鐩� **546 瀹�**锛堟瘮鍚嶇О鍙ｅ緞澶� 1 瀹舵敼鍚嶄紒涓氾細
+ `91420112558443820B`锛�2025-01~09銆屾箹鍖椾笁宄″瘜鐑ㄧ豢鐢典緵搴旈摼鏈夐檺鍏徃銆嶁啋 2025-10 璧枫�屾箹鍖楅暱宄″瘜鐑ㄧ豢鐢典緵搴旈摼鏈夐檺鍏徃銆嶏級锛�
+ 杈撳嚭 14 鍒楋紙淇＄敤浠ｇ爜銆佷袱骞村悕绉般�佹槸鍚︽敼鍚嶃�佸競宸炪�佷袱骞磋揣杩愰噺/鍛ㄨ浆閲忓強澧炲噺鍚屾瘮锛夛紝鎸� 2026 骞磋揣杩愰噺闄嶅簭銆�
+- 546 瀹跺彛寰勫悎璁★細2025 骞� 1-8 鏈� 30162.99 涓囧惃 / 4637038.58 涓囧惃鍏噷锛�2026 骞� 27764.88 涓囧惃 / 4392984.81 涓囧惃鍏噷銆�
+- 鑴氭湰鍐呴檮涓夌瀵煎嚭鏂瑰紡锛堝懡浠よ tsv / Navicat 瀵� xlsx / INTO OUTFILE锛夛紝鍛戒护琛屾柟寮忓凡瀹炴祴瀵煎嚭 546 琛屻�佷腑鏂囨甯搞��
+- 寰呯敤鎴风‘璁わ細瀵瑰鎶ラ�佺敤 545 瀹讹紙鍚嶇О浜ら泦锛夎繕鏄� 546 瀹讹紙浠ｇ爜浜ら泦锛夛紝纭鍚庡啀瀹氱浠躲��
## 浜屻�佹祴璇曠粨鏋滄憳瑕�
瑙併�婂姛鑳芥祴璇曟姤鍛奯鎸佺画鍦ㄨ浼佷笟545瀹跺垎甯傚窞绱杩愯窛鍚屾瘮_2026-09-19.md銆嬶細11 鏉＄敤渚嬶紙7 姝ｅ悜 / 3 杈圭晫 / 1 璐熷悜锛夊叏閮ㄩ�氳繃銆�
@@ -62,7 +70,7 @@
- 鍏ㄧ渷琛� = 危17 甯傚窞锛�17 涓競宸炰笌鐢ㄦ埛琛ㄦ牸閫愯涓�鑷达紱
- 浠欐甯傛棤鍙瘮鍩烘暟銆佺疮璁¤揣杩愰噺涓� 0 鐨勪紒涓氬潎宸查槻闄ら浂澶勭悊銆�
-- 鍚屽悕浼佷笟鍙ｅ緞 SQL 鑴氭湰宸叉暣鑴氭湰鎵ц楠岃瘉锛�12 鏉＄敤渚嬶紙8 姝ｅ悜 / 2 璐熷悜 / 2 杈圭晫锛夊叏閮ㄩ�氳繃锛�
+- 鍚屽悕浼佷笟鍙ｅ緞 SQL 鑴氭湰宸叉暣鑴氭湰鎵ц楠岃瘉锛堝惈杩藉姞鐨勬槑缁嗗鍑烘煡璇級锛�17 鏉＄敤渚嬶紙11 姝ｅ悜 / 2 璐熷悜 / 4 杈圭晫锛夊叏閮ㄩ�氳繃锛�
鏄庣粏 545 琛屾眰鍜� = 姹囨�昏锛堝樊寮� 0锛夛紝宸紓浼佷笟闂悎鏍￠獙閫氳繃銆�
## 涓夈�侀仐鐣欓棶棰樹笌寰呭姙
diff --git "a/docs/\347\224\237\346\210\220\346\261\207\346\200\273\345\244\247\350\241\250/\345\220\214\345\220\215\344\274\201\344\270\232_1-8\346\234\210\347\264\257\350\256\241\345\257\271\346\257\224_2026-09-19.sql" "b/docs/\347\224\237\346\210\220\346\261\207\346\200\273\345\244\247\350\241\250/\345\220\214\345\220\215\344\274\201\344\270\232_1-8\346\234\210\347\264\257\350\256\241\345\257\271\346\257\224_2026-09-19.sql"
index 48d4700..7fd1adc 100644
--- "a/docs/\347\224\237\346\210\220\346\261\207\346\200\273\345\244\247\350\241\250/\345\220\214\345\220\215\344\274\201\344\270\232_1-8\346\234\210\347\264\257\350\256\241\345\257\271\346\257\224_2026-09-19.sql"
+++ "b/docs/\347\224\237\346\210\220\346\261\207\346\200\273\345\244\247\350\241\250/\345\220\214\345\220\215\344\274\201\344\270\232_1-8\346\234\210\347\264\257\350\256\241\345\257\271\346\257\224_2026-09-19.sql"
@@ -198,4 +198,99 @@
WHERE report_period BETWEEN '2026-01' AND '2026-08') b ON b.enterprise_name = e.enterprise_name
WHERE e.report_period BETWEEN '2025-01' AND '2026-08'
GROUP BY e.enterprise_name
-HAVING 璁板綍鏁�2025 <> 8 OR 璁板綍鏁�2026 <> 8;
\ No newline at end of file
+HAVING 璁板綍鏁�2025 <> 8 OR 璁板綍鏁�2026 <> 8;
+-- =====================================================================
+-- 鏌ヨ 7锛氫紒涓氭槑缁嗗鍑猴紙鎺ㄨ崘鐢ㄨ繖鐗堬紝546 瀹讹級
+-- 涓庢煡璇� 2 鐨勫尯鍒細鍖归厤閿敤銆岀粺涓�绀句細淇＄敤浠ｇ爜銆嶈�屼笉鏄紒涓氬悕绉帮紝
+-- 澶氳鐩� 1 瀹舵敼鍚嶄紒涓氾紙91420112558443820B锛�
+-- 2025-01~2025-09 鍙�屾箹鍖椾笁宄″瘜鐑ㄧ豢鐢典緵搴旈摼鏈夐檺鍏徃銆嶏紝
+-- 2025-10 璧峰彨銆屾箹鍖楅暱宄″瘜鐑ㄧ豢鐢典緵搴旈摼鏈夐檺鍏徃銆嶏級锛�
+-- 鏌ヨ 2 鎸夊悕绉板尮閰嶄細鎶婅繖瀹朵袱骞撮兘婕忔帀锛屼笖鍚屾椂璁″叆涓ゅ勾銆岀嫭鏈変紒涓氥�嶅悕鍗曘��
+-- 杈撳嚭鍒楀凡鎸夊鍑轰範鎯帓濂斤紝鍙洿鎺ョ矘杩� Excel锛涙寜 2026 骞磋揣杩愰噺闄嶅簭銆�
+-- 鎻愮ず锛氭槑缁嗚鏄�屽厛鍥涜垗浜斿叆鍐嶆眰鍜屻�嶏紝涓庢煡璇� 8 鐨勫悎璁℃湁 0.01~0.02 鐨勫熬宸紝灞炴甯搞��
+-- =====================================================================
+SELECT d.credit_code AS 缁熶竴绀句細淇＄敤浠ｇ爜,
+ d.name_2026 AS 浼佷笟鍚嶇О,
+ d.name_2025 AS 鍚嶇О2025,
+ IF(d.name_2025 <> d.name_2026, '鏄�', '') AS 鏄惁鏀瑰悕,
+ CASE
+ WHEN d.region_code LIKE '4201%' THEN '姝︽眽' WHEN d.region_code LIKE '4202%' THEN '榛勭煶'
+ WHEN d.region_code LIKE '4203%' THEN '鍗佸牥' WHEN d.region_code LIKE '4205%' THEN '瀹滄槍'
+ WHEN d.region_code LIKE '4206%' THEN '瑗勯槼' WHEN d.region_code LIKE '4207%' THEN '閯傚窞'
+ WHEN d.region_code LIKE '4208%' THEN '鑽嗛棬' WHEN d.region_code LIKE '4209%' THEN '瀛濇劅'
+ WHEN d.region_code LIKE '4210%' THEN '鑽嗗窞' WHEN d.region_code LIKE '4211%' THEN '榛勫唸'
+ WHEN d.region_code LIKE '4212%' THEN '鍜稿畞' WHEN d.region_code LIKE '4213%' THEN '闅忓窞'
+ WHEN d.region_code LIKE '4228%' THEN '鎭╂柦' WHEN d.region_code LIKE '429004%' THEN '浠欐'
+ WHEN d.region_code LIKE '429005%' THEN '娼滄睙' WHEN d.region_code LIKE '429006%' THEN '澶╅棬'
+ WHEN d.region_code LIKE '429021%' THEN '鏋楀尯' ELSE '鍏朵粬' END AS 甯傚窞,
+ d.region_code AS 鍦板尯浠ｇ爜,
+ ROUND(d.freight_2025 / 10000, 2) AS 璐ц繍閲�2025_涓囧惃,
+ ROUND(d.freight_2026 / 10000, 2) AS 璐ц繍閲�2026_涓囧惃,
+ ROUND((d.freight_2026 - d.freight_2025) / 10000, 2) AS 璐ц繍閲忓鍑廮涓囧惃,
+ ROUND((d.freight_2026 / NULLIF(d.freight_2025, 0) - 1) * 100, 2) AS 璐ц繍閲忓悓姣擾鐧惧垎姣�,
+ ROUND(d.turnover_2025 / 10000, 2) AS 鍛ㄨ浆閲�2025_涓囧惃鍏噷,
+ ROUND(d.turnover_2026 / 10000, 2) AS 鍛ㄨ浆閲�2026_涓囧惃鍏噷,
+ ROUND((d.turnover_2026 - d.turnover_2025) / 10000, 2) AS 鍛ㄨ浆閲忓鍑廮涓囧惃鍏噷,
+ ROUND((d.turnover_2026 / NULLIF(d.turnover_2025, 0) - 1) * 100, 2) AS 鍛ㄨ浆閲忓悓姣擾鐧惧垎姣�
+FROM (
+ SELECT e.unified_credit_code AS credit_code,
+ -- 2026 骞寸敤鐨勫悕瀛楋紙鏀瑰悕鍚庡彇鏂板悕锛夈��2025 骞寸敤鐨勫悕瀛楋紝鐢ㄤ簬鏍囪鏀瑰悕
+ MAX(CASE WHEN e.report_period >= '2026-01' THEN e.enterprise_name END) AS name_2026,
+ MAX(CASE WHEN e.report_period <= '2025-08' THEN e.enterprise_name END) AS name_2025,
+ MAX(CASE WHEN e.report_period >= '2026-01' THEN e.region_code END) AS region_code,
+ SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END) AS freight_2025,
+ SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END) AS freight_2026,
+ SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END) AS turnover_2025,
+ SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END) AS turnover_2026
+ FROM h2032_enterprise_monthly e
+ JOIN (SELECT DISTINCT unified_credit_code c FROM h2032_enterprise_monthly
+ WHERE report_period BETWEEN '2025-01' AND '2025-08') a ON a.c = e.unified_credit_code
+ JOIN (SELECT DISTINCT unified_credit_code c FROM h2032_enterprise_monthly
+ WHERE report_period BETWEEN '2026-01' AND '2026-08') b ON b.c = e.unified_credit_code
+ WHERE e.report_period BETWEEN '2025-01' AND '2026-08'
+ GROUP BY e.unified_credit_code
+) d
+ORDER BY 璐ц繍閲�2026_涓囧惃 DESC;
+
+
+-- =====================================================================
+-- 鏌ヨ 8锛氭煡璇� 7 鐨勫悎璁¤锛堝鍑烘槑缁嗗悗鐢ㄦ潵瀵规�绘暟锛�546 瀹跺彛寰勶級
+-- 2025 骞� 1-8 鏈堬細璐ц繍閲� 30162.99 涓囧惃銆佸懆杞噺 4637038.58 涓囧惃鍏噷
+-- 2026 骞� 1-8 鏈堬細璐ц繍閲� 27764.88 涓囧惃銆佸懆杞噺 4392984.81 涓囧惃鍏噷
+-- =====================================================================
+SELECT COUNT(DISTINCT e.unified_credit_code) AS 浼佷笟鏁�,
+ ROUND(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END) / 10000, 2) AS 璐ц繍閲�2025_涓囧惃,
+ ROUND(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END) / 10000, 2) AS 璐ц繍閲�2026_涓囧惃,
+ ROUND(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END) / 10000, 2) AS 鍛ㄨ浆閲�2025_涓囧惃鍏噷,
+ ROUND(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END) / 10000, 2) AS 鍛ㄨ浆閲�2026_涓囧惃鍏噷
+FROM h2032_enterprise_monthly e
+JOIN (SELECT DISTINCT unified_credit_code c FROM h2032_enterprise_monthly
+ WHERE report_period BETWEEN '2025-01' AND '2025-08') a ON a.c = e.unified_credit_code
+JOIN (SELECT DISTINCT unified_credit_code c FROM h2032_enterprise_monthly
+ WHERE report_period BETWEEN '2026-01' AND '2026-08') b ON b.c = e.unified_credit_code
+WHERE e.report_period BETWEEN '2025-01' AND '2026-08';
+
+
+-- =====================================================================
+-- 涓夈�佹�庝箞鎶婃煡璇� 7 鐨勭粨鏋滃鍑烘潵
+-- ---------------------------------------------------------------------
+-- 鏂瑰紡涓�锛氬懡浠よ瀵煎嚭锛堣緭鍑哄埗琛ㄧ鍒嗛殧鐨� .tsv锛孍xcel 鍙屽嚮鍗冲彲鍒嗗垪锛屾渶鐪佷簨锛�
+-- mysql --host=127.0.0.1 --port=3308 --user=root --password=123456 ^
+-- --database=traffic_audit --default-character-set=utf8mb4 --batch --raw ^
+-- --execute="杩欓噷鏁存绮樿创鏌ヨ 7 鐨� SQL锛堝惈鏈�澶栧眰鍒嗗彿涔嬪墠鐨勫叏閮ㄥ唴瀹癸級" ^
+-- > D:\涓存椂\浼佷笟鏄庣粏_546瀹禵2025-2026骞�1-8鏈�.tsv
+-- 娉ㄦ剰 1锛氫竴瀹氳甯� --default-character-set=utf8mb4锛屽惁鍒欎腑鏂囧垪鍚�/浼佷笟鍚嶄細鍙樹贡鐮併��
+-- 娉ㄦ剰 2锛氬鍑虹殑 .tsv 鏄�孶TF-8 鏃� BOM銆嶏紝閮ㄥ垎浜虹殑 Excel 鐩存帴鍙屽嚮浼氭樉绀轰贡鐮侊紝
+-- 璇锋敼鐢� Excel 鐨勩�屾暟鎹� 鈫� 浠庢枃鏈�/CSV銆嶅鍏ュ苟閫� UTF-8 缂栫爜锛�
+-- 鎴栫洿鎺ョ敤涓嬮潰鐨勬柟寮忎簩瀵煎嚭鎴� xlsx锛堟渶涓嶅鏄撳嚭闂锛夈��
+
+--
+-- 鏂瑰紡浜岋細鏌ヨ宸ュ叿瀵煎嚭锛堟帹鑽愮粰涓嶇啛鍛戒护琛岀殑鍦烘櫙锛�
+-- 鍦� Navicat / MySQL Workbench / DBeaver 閲岀洿鎺ユ墽琛屾煡璇� 7锛�
+-- 鍙抽敭缁撴灉缃戞牸 鈫掋�屽鍑虹粨鏋溿�嶁啋 閫� xlsx 鎴� csv 鍗冲彲銆�
+--
+-- 鏂瑰紡涓夛細MySQL 鏈嶅姟绔洿鎺ュ啓鏂囦欢锛堜竴鑸笉鐢級
+-- 闇�瑕佹湇鍔＄ secure_file_priv 鍏佽鐩爣鐩綍锛屼笖璺緞鏄�屾湇鍔″櫒涓娿�嶇殑璺緞锛�
+-- SELECT ... INTO OUTFILE 'D:/tmp/freight_detail.csv'
+-- FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
+-- 鍏堟煡 secure_file_priv锛歋HOW VARIABLES LIKE 'secure_file_priv';
\ No newline at end of file
--
Gitblit v1.9.1