trafficAudit.git

			@@ -16,28 +16,50 @@
			-- 2025 å¹´ 1-8 ææ 664 å®¶ä¼ä¸ã2026 å¹´ 1-8 æåªæ 636 å®¶ï¼
			-- ç´æ¥æ¿ä¸¤å¹´æ»æ°ç¸åï¼å·®é¢éæ··çãä¼ä¸æ°éåäºãçå½±åï¼ä¸æ¯çå®å¢åã
			-- æä¸¤å¹´é½æ¥éè¿çä¼ä¸åç§°åäº¤éï¼å®æµ 545 å®¶ï¼ï¼ä¸¤å¹´çä¼ä¸èå´æä¸è´ã
			-- å®æµç»æï¼ååä¼ä¸å£å¾ 545 å®¶ï¼ï¼
			-- 2025 å¹´ 1-8 æï¼è´§è¿é 30153.14 ä¸å¨ï¼å¨è½¬é 4635340.46 ä¸å¨å¬é
			-- 2026 å¹´ 1-8 æï¼è´§è¿é 27752.68 ä¸å¨ï¼å¨è½¬é 4389882.05 ä¸å¨å¬é
			-- åæ¯ï¼è´§è¿é -7.96%ï¼å¨è½¬é -5.30%
			-- å®æµç»æï¼ååä¼ä¸å£å¾ 545 å®¶ï¼4 ä½å°æ°ï¼ï¼
			-- 2025 å¹´ 1-8 æï¼è´§è¿é 30153.1392 ä¸å¨ï¼å¨è½¬é 4635340.4627 ä¸å¨å¬é
			-- 2026 å¹´ 1-8 æï¼è´§è¿é 27752.6820 ä¸å¨ï¼å¨è½¬é 4389882.0468 ä¸å¨å¬é
			-- åæ¯ï¼è´§è¿é -7.9609%ï¼å¨è½¬é -5.2954%
			-- ï¼2026 å¹´è¿ä¸¤ä¸ªæ°ä¸ãæç»å¨è§ä¼ä¸545å®¶_åå¸å·1-8æç´¯è®¡è¿è·ååæ¯ãäº¤ä»ä»¶çå¨çè¡å®å¨ä¸è´ï¼
			-- ============================================================


			-- ============================================================
			-- â å°æ°ä½çº¦å®ï¼2026-09-19 è¡¥åï¼å¾éè¦ï¼â
			-- ------------------------------------------------------------
			-- 1) è¡¨éåçæ¯ãå¨ / å¨å¬éãçæ´æ°ï¼å¯¼åºæ¶ Ã·10000 åæãä¸å¨ / ä¸å¨å¬éãã
			-- 2) å¡æ¯ãè¦æ¿å»äºæ¬¡è®¡ç®ãçåï¼å°¤å¶æ¯ãå¨è½¬é Ã· è´§è¿é = å¹³åè¿è·ãï¼ï¼
			-- åä¸ä¸è½å¨ SQL éåªä¿ç 2 ä½å°æ°ï¼
			-- åå ï¼ä¿ç 2 ä½ = ç²¾åº¦å° 100 å¨ãå¯¹è´§è¿éåªæå åå¨çå°ä¼ä¸ï¼
			-- åæ¯ä¼è¢«ç ææå¤ 1%ï¼ç®åºæ¥çè¿è·è½å·®åºå¥½å å¬éã
			-- å®ä¾ï¼æ¹åå¼é·ç©æµæéå¬å¸ 2026 å¹´ 1-8 æè´§è¿é 4631 å¨
			-- â ä¸åæ´ 0.4631 ä¸å¨ï¼è¿è· 1267.05 å¬éï¼æ£ç¡®ï¼
			-- â å 2 ä½ 0.46 ä¸å¨ï¼è¿è· 1275.59 å¬éï¼èé« 8.53 å¬éï¼
			-- 3) æä»¥æ¬èæ¬çº¦å®ï¼
			-- Â· æç»ç±»æ¥è¯¢ï¼æ¥è¯¢ 2ãæ¥è¯¢ 7ï¼â å®å¨ä¸å¥ ROUNDï¼å¯¼åºå³åå§å¼
			-- ï¼è´§è¿é/å¨è½¬éçåå§å¼æå¤ 4 ä½å°æ°ï¼å°±æ¯å¨ç²¾åº¦ï¼åæ¯åå°æ°ä½è¾é¿ï¼
			-- å«é¿å¯èªè¡å¨å¤é¢å¥ ROUND(...,2)ï¼ï¼
			-- Â· æ±æ»ç±»ï¼æ¥è¯¢ 1ã3ã5ã8ï¼â åæ ·ä¿ç 4 ä½å°æ°ï¼å¯¹æ¬è¡¨æ°æ®æ¥è¯´ 4 ä½å°±æ¯å¨ç²¾åº¦ï¼
			-- ä¿ç 2 ä½æ²¡æä»»ä½å¥½å¤ï¼åèä¼è®©äººè¯¯ä»¥ä¸ºæ°æ®å°±åªæ 2 ä½ç²¾åº¦ï¼ï¼
			-- Â· å¦æä½ è¦èªå·±ç®è¿è·/åæ¯ï¼å»ºè®®ç´æ¥ç¨æ¥è¯¢ 7ï¼ææ /10000 é£ä¸å±å»æï¼
			-- åå¨ Excel éæãå¨ãç®å®åé¤ã
			-- ============================================================

			-- =====================================================================
			-- æ¥è¯¢ 1ï¼æ±æ»ä¸è¡ ââ ååä¼ä¸å£å¾çä¸¤å¹´ç´¯è®¡æ° + åæ¯å¢é
			-- =====================================================================
			SELECT COUNT(DISTINCT e.enterprise_name) AS ä¼ä¸æ°,
			ROUND(SUM(CASE WHEN e.report_period <= '2025-08'
			THEN e.freight_total ELSE 0 END) / 10000, 2) AS è´§è¿é2025_ä¸å¨,
			THEN e.freight_total ELSE 0 END) / 10000, 4) AS è´§è¿é2025_ä¸å¨,
			ROUND(SUM(CASE WHEN e.report_period >= '2026-01'
			THEN e.freight_total ELSE 0 END) / 10000, 2) AS è´§è¿é2026_ä¸å¨,
			THEN e.freight_total ELSE 0 END) / 10000, 4) AS è´§è¿é2026_ä¸å¨,
			ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END)
			/ NULLIF(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END), 0) - 1) * 100, 2)
			AS è´§è¿éåæ¯_ç¾åæ¯,
			ROUND(SUM(CASE WHEN e.report_period <= '2025-08'
			THEN e.turnover_total ELSE 0 END) / 10000, 2) AS å¨è½¬é2025_ä¸å¨å¬é,
			THEN e.turnover_total ELSE 0 END) / 10000, 4) AS å¨è½¬é2025_ä¸å¨å¬é,
			ROUND(SUM(CASE WHEN e.report_period >= '2026-01'
			THEN e.turnover_total ELSE 0 END) / 10000, 2) AS å¨è½¬é2026_ä¸å¨å¬é,
			THEN e.turnover_total ELSE 0 END) / 10000, 4) AS å¨è½¬é2026_ä¸å¨å¬é,
			ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END)
			/ NULLIF(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END), 0) - 1) * 100, 2)
			AS å¨è½¬éåæ¯_ç¾åæ¯
			@@ -56,20 +78,20 @@
			-- æ¥è¯¢ 2ï¼éä¼ä¸å¯¹ç§æç»ï¼ååä¼ä¸ï¼ä¸¤å¹´å¹¶æï¼ï¼å¯ç´æ¥å¯¼åº Excel
			-- æ 2026 å¹´è´§è¿éä»å¤§å°å°æï¼å»æ ORDER BY å°±æ¯å®æ´ 545 è¡ã
			-- =====================================================================
			SELECT e.enterprise_name AS ä¼ä¸åç§°,
			MAX(CASE WHEN e.report_period >= '2026-01' THEN e.region_code END) 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 >= '2026-01' THEN e.freight_total ELSE 0 END)
			- SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END)) / 10000, 2) AS è´§è¿éå¢å_ä¸å¨,
			ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END)
			/ NULLIF(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END), 0) - 1) * 100, 2) AS è´§è¿éåæ¯_ç¾åæ¯,
			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_ä¸å¨å¬é,
			ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END)
			- SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END)) / 10000, 2) AS å¨è½¬éå¢å_ä¸å¨å¬é,
			ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END)
			/ NULLIF(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END), 0) - 1) * 100, 2) AS å¨è½¬éåæ¯_ç¾åæ¯
			SELECT e.enterprise_name AS ä¼ä¸åç§°,
			MAX(CASE WHEN e.report_period >= '2026-01' THEN e.region_code END) AS å°åºä»£ç ,
			SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END) / 10000 AS è´§è¿é2025_ä¸å¨,
			SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END) / 10000 AS è´§è¿é2026_ä¸å¨,
			(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END)
			- SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END)) / 10000 AS è´§è¿éå¢å_ä¸å¨,
			(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END)
			/ NULLIF(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END), 0) - 1) * 100 AS è´§è¿éåæ¯_ç¾åæ¯,
			SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END) / 10000 AS å¨è½¬é2025_ä¸å¨å¬é,
			SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END) / 10000 AS å¨è½¬é2026_ä¸å¨å¬é,
			(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END)
			- SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END)) / 10000 AS å¨è½¬éå¢å_ä¸å¨å¬é,
			(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END)
			/ NULLIF(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END), 0) - 1) * 100 AS å¨è½¬éåæ¯_ç¾åæ¯
			FROM h2032_enterprise_monthly e
			JOIN (SELECT DISTINCT enterprise_name FROM h2032_enterprise_monthly
			WHERE report_period BETWEEN '2025-01' AND '2025-08') a
			@@ -89,8 +111,8 @@
			-- =====================================================================
			SELECT t.scope_type AS å£å¾,
			COUNT(DISTINCT t.enterprise_name) AS ä¼ä¸æ°,
			ROUND(SUM(t.freight_total) / 10000, 2) AS è´§è¿é_ä¸å¨,
			ROUND(SUM(t.turnover_total) / 10000, 2) AS å¨è½¬é_ä¸å¨å¬é
			ROUND(SUM(t.freight_total) / 10000, 4) AS è´§è¿é_ä¸å¨,
			ROUND(SUM(t.turnover_total) / 10000, 4) AS å¨è½¬é_ä¸å¨å¬é
			FROM (
			SELECT 'ALL_2025' AS scope_type, enterprise_name, freight_total, turnover_total
			FROM h2032_enterprise_monthly WHERE report_period BETWEEN '2025-01' AND '2025-08'
			@@ -160,10 +182,10 @@
			WHEN region_code LIKE '429005%' THEN 'æ½æ±' WHEN region_code LIKE '429006%' THEN 'å¤©é¨'
			WHEN region_code LIKE '429021%' THEN 'æåº' ELSE 'å¶ä»' END AS å¸å·,
			COUNT(DISTINCT d.enterprise_name) AS ååä¼ä¸æ°,
			ROUND(SUM(d.freight_2025) / 10000, 2) AS è´§è¿é2025_ä¸å¨,
			ROUND(SUM(d.freight_2026) / 10000, 2) AS è´§è¿é2026_ä¸å¨,
			ROUND(SUM(d.turnover_2025) / 10000, 2) AS å¨è½¬é2025_ä¸å¨å¬é,
			ROUND(SUM(d.turnover_2026) / 10000, 2) AS å¨è½¬é2026_ä¸å¨å¬é
			ROUND(SUM(d.freight_2025) / 10000, 4) AS è´§è¿é2025_ä¸å¨,
			ROUND(SUM(d.freight_2026) / 10000, 4) AS è´§è¿é2026_ä¸å¨,
			ROUND(SUM(d.turnover_2025) / 10000, 4) AS å¨è½¬é2025_ä¸å¨å¬é,
			ROUND(SUM(d.turnover_2026) / 10000, 4) AS å¨è½¬é2026_ä¸å¨å¬é
			FROM (
			SELECT e.enterprise_name,
			MAX(CASE WHEN e.report_period >= '2026-01' THEN e.region_code END) AS region_code,
			@@ -198,4 +220,100 @@
			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;
			HAVING è®°å½æ°2025 <> 8 OR è®°å½æ°2026 <> 8;
			-- =====================================================================
			-- æ¥è¯¢ 7ï¼ä¼ä¸æç»å¯¼åºï¼æ¨èç¨è¿çï¼546 å®¶ï¼
			-- ä¸æ¥è¯¢ 2 çåºå«ï¼å¹éé®ç¨ãç»ä¸ç¤¾ä¼ä¿¡ç¨ä»£ç ãèä¸æ¯ä¼ä¸åç§°ï¼
			-- å¤è¦ç 1 å®¶æ¹åä¼ä¸ï¼91420112558443820Bï¼
			-- 2025-01~2025-09 å«ãæ¹åä¸å³¡å¯ç¨ç»¿çµä¾åºé¾æéå¬å¸ãï¼
			-- 2025-10 èµ·å«ãæ¹åé¿å³¡å¯ç¨ç»¿çµä¾åºé¾æéå¬å¸ãï¼ï¼
			-- æ¥è¯¢ 2 æåç§°å¹éä¼æè¿å®¶ä¸¤å¹´é½æ¼æï¼ä¸åæ¶è®¡å¥ä¸¤å¹´ãç¬æä¼ä¸ãååã
			-- è¾åºåå·²æå¯¼åºä¹ æ¯æå¥½ï¼å¯ç´æ¥ç²è¿ Excelï¼æ 2026 å¹´è´§è¿ééåºã
			-- æç¤ºï¼æç»åä¸å¥ ROUNDï¼å¨ç²¾åº¦ï¼è´§è¿é/å¨è½¬éæå¤ 4 ä½å°æ°ï¼ï¼
			-- ä¸æ¥è¯¢ 8 ç 2 ä½åè®¡ä¼æ 0.01 çº§å°¾å·®ï¼å±æ£å¸¸ã
			-- =====================================================================
			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 å°åºä»£ç ,
			d.freight_2025 / 10000 AS è´§è¿é2025_ä¸å¨,
			d.freight_2026 / 10000 AS è´§è¿é2026_ä¸å¨,
			(d.freight_2026 - d.freight_2025) / 10000 AS è´§è¿éå¢å_ä¸å¨,
			(d.freight_2026 / NULLIF(d.freight_2025, 0) - 1) * 100 AS è´§è¿éåæ¯_ç¾åæ¯,
			d.turnover_2025 / 10000 AS å¨è½¬é2025_ä¸å¨å¬é,
			d.turnover_2026 / 10000 AS å¨è½¬é2026_ä¸å¨å¬é,
			(d.turnover_2026 - d.turnover_2025) / 10000 AS å¨è½¬éå¢å_ä¸å¨å¬é,
			(d.turnover_2026 / NULLIF(d.turnover_2025, 0) - 1) * 100 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.9872 ä¸å¨ãå¨è½¬é 4637038.5803 ä¸å¨å¬é
			-- 2026 å¹´ 1-8 æï¼è´§è¿é 27764.8812 ä¸å¨ãå¨è½¬é 4392984.8116 ä¸å¨å¬é
			-- =====================================================================
			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, 4) AS è´§è¿é2025_ä¸å¨,
			ROUND(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END) / 10000, 4) AS è´§è¿é2026_ä¸å¨,
			ROUND(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END) / 10000, 4) AS å¨è½¬é2025_ä¸å¨å¬é,
			ROUND(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END) / 10000, 4) 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ï¼Excel åå»å³å¯ååï¼æçäºï¼
			-- 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 æ¯ãUTF-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ï¼SHOW VARIABLES LIKE 'secure_file_priv';