鈥?strong>鈥嬪搸锛屼綘瀵煎嚭鐨勬暟鎹槸涓嶆槸鎬诲儚琚嫍鍟冭繃锛熲€?/strong>鈥?br/> 姣斿鎯虫妸鐪併€佸競銆佸尯鎷兼垚"鍖椾含-鏈濋槼鍖?鏈涗含"锛岀粨鏋滃鍑烘潵鍙樻垚浜?鍖椾含鏈濋槼鍖烘湜浜?锛熸垨鑰呮兂鎶婅鍗曟棩鏈熷拰璁㈠崟鍙峰悎骞讹紝缁撴灉榛忔垚涓€鍧?2023080110001"锛熶粖澶╁挶浠氨鎺板紑浜嗘弶纰庝簡璁茶锛屾€庝箞鐢⊿QL缁欐煡璇㈢粨鏋溾€?strong>鈥嬩紭闆呭湴鍔犲垎闅旂鈥?/strong>鈥嬶紒

鈻庡厛鐪嬬炕杞︾幇鍦猴細涓嶅姞鍒嗛殧绗︽湁澶氬彲鎬曪紵

鍋囪浣犱粠鏁版嵁搴撳鍑轰簡鐢ㄦ埛鍦板潃琛細

鎯宠鍚堝苟鎴?鐪佷唤-鍩庡競-鍖哄煙"鐨勬牸寮忥紝缁撴灉鍐欐垚锛?/p>

sql澶嶅埗
SELECT 鐪佷唤||鍩庡競||鍖哄煙 FROM 鍦板潃琛? -- Oracle鍐欐硶

杈撳嚭鐩存帴鍙樻垚"鍖椾含鍖椾含鏈濋槼鍖?...鈥?strong>鈥嬭繖璋佺湅寰楁噦鍟婏紒鈥?/strong>鈥嬶紙鑰佹澘鐪嬩簡鎬曟槸瑕佹墸楦¤吙锛?/p>

鈻庡洓澶ф暟鎹簱鐨?鑳舵按"閰嶆柟

鈥?strong>鈥媉閲嶇偣鏉ヤ簡锛乢鈥?/strong>鈥?涓嶅悓鏁版嵁搴撳姞鍒嗛殧绗︾殑濂楄矾瀹屽叏涓嶄竴鏍凤紝鍜变滑鐩存帴涓婂姣旇〃锛?/p>

涓句釜鏍楀瓙馃尠锛氬綋鍩庡競瀛楁涓篘ULL鏃?/p>

sql澶嶅埗
-- MySQL瀹夊叏妯″紡  
SELECT CONCAT(鐪佷唤,'-',鍩庡競,'-',鍖哄煙)  
--> 鍖椾含--鏈濋槼鍖? 

-- SQL Server楂樺嵄妯″紡  
SELECT 鐪佷唤+'-'+鍩庡競+'-'+鍖哄煙  
--> NULL  

锛堢湅鍑哄樊鍒簡鍚э紵PostgreSQL鐪熸槸璐村績灏忔琚勶紒锛?/p>

鈻庢墜鎶婃墜鏁欏锛氬姞鍒嗛殧绗︾殑姝ｇ‘濮垮娍

绗竴姝ワ細鍩虹娆撅紙浠ュ寳浜湴鍧€涓轰緥锛?/h3>

sql澶嶅埗
-- MySQL淇濆懡鍐欐硶  
SELECT CONCAT(鐪佷唤,'-',鍩庡競,'-',鍖哄煙) AS 瀹屾暣鍦板潃  

-- SQL Server杞瀷澶ф硶  
SELECT 鐪佷唤+'-'+ISNULL(鍩庡競,'')+'-'+ISNULL(鍖哄煙,'')  

-- Oracle闃茬炕杞︽柟妗? 
SELECT 鐪佷唤 || '-' || NVL(鍩庡競,' ') || '-' || NVL(鍖哄煙,' ')  

鈥?strong>鈥媉娉ㄦ剰锛乢鈥?/strong>鈥?鐢ㄧ┖鏍间唬鏇跨┖瀛楃涓诧紝閬垮厤鍑虹幇"鍖椾含--鏈濋槼鍖?杩欑鍙屾潬鎯ㄦ

---

绗簩姝ワ細澶勭悊鏁板瓧鍜屾棩鏈?/h3>

鎯虫妸璁㈠崟鏃ユ湡鍜屾暟閲忔嫾鎴?2023-08-01 * 5"鎬庝箞鍔烇紵

sql澶嶅埗
-- 閫氱敤杞瀷妯℃澘  
SELECT 
    CONCAT(
        DATE_FORMAT(璁㈠崟鏃ユ湡,'%Y-%m-%d'),  -- MySQL鏃ユ湡鏍煎紡鍖?/span>
        '*', 
        CAST(鏁伴噺 AS CHAR)               -- 鏁板瓧杞瓧绗︿覆
    )  

鈥?strong>鈥媉琛€娉暀璁細_鈥?/strong>鈥?鏇剧粡鍥犱负蹇樿杞瀷锛屾妸鏁伴噺123鎷兼帴鎴愪贡鐮侊紝琚储鍔￠儴杩芥潃涓夋潯琛?..

---

绗笁姝ワ細鐜╄浆鐗规畩鍒嗛殧绗?/h3>

鎯崇敤鏂滄潬/鎷兼帴鎬庝箞鍔烇紵

sql澶嶅埗
-- 鎵€鏈夋暟鎹簱閫氱敤鎶€宸? 
SELECT 鐪佷唤||'/'||鍩庡競||'/'||鍖哄煙  -- 鐢ㄥ崟寮曞彿鍖呬綇鏂滄潬

鈥?strong>鈥媉浣嗚娉ㄦ剰锛歘鈥?/strong>鈥?鍦⊿QL Server閲屽鏋滅敤+鍙锋嫾鎺ユ枩鏉狅紝鍙兘浼氳璇涓鸿繍绠楃锛岃繖鏃跺€欒寰楀姞绌烘牸锛?/p>

sql澶嶅埗
SELECT 鐪佷唤 + '/' + 鍩庡競  -- 姝ｇ‘  
SELECT 鐪佷唤+/+鍩庡競         -- 鎶ラ敊锛?/span>

---

鈻庝綘浠渶鐖遍棶鐨勯棶棰?/h2>

鈥?strong>鈥婹锛氬瓧娈靛お澶氬啓鍒版墜鎶界瓔鎬庝箞鍔烇紵鈥?/strong>鈥?br/> A锛氭暀浣犱釜鐙棬绉樼睄鈥斺€旂敤VSCode鐨勫鍏夋爣缂栬緫锛?/p>

1. 鍏堝垪鍑烘墍鏈夊瓧娈碉細鐪佷唤,鍩庡競,鍖哄煙,琛楅亾
2. 鎸堿lt+榧犳爣宸﹂敭鍦ㄦ瘡涓瓧娈靛悗闈㈡坊鍔犲垎闅旂
   锛堝叿浣撴搷浣滅湅鍥撅紝鍖呬綘3绉掓悶瀹?0涓瓧娈碉級

鈥?strong>鈥婹锛氭兂鍦ㄧ粨鏋滈噷鎹㈣鏄剧ず鎬庝箞鍔烇紵鈥?/strong>鈥?br/> A锛氱敤ASCII鐮佹帶鍒剁锛?/p>

sql澶嶅埗
-- 閫氱敤鎹㈣绗? 
SELECT CONCAT(鍦板潃, CHAR(13)+CHAR(10), 鑱旂郴鐢佃瘽)  -- CHAR(13)鏄洖杞︼紝CHAR(10)鎹㈣

---

鈻庡皬缂栫殑韪╁潙鏃ヨ

鍘诲勾鍋氬勾缁堟姤琛ㄦ椂锛岀敤Oracle鍐欎簡杩欎箞涓鍙ワ細

sql澶嶅埗
SELECT 閮ㄩ棬||' '||濮撳悕||':'||缁╂晥鍒?FROM 鍛樺伐琛? 

缁撴灉缁╂晥鍒嗘槸NUMBER绫诲瀷鐩存帴鎶ラ敊锛佹渶鍚庡彂鐜拌鏀规垚锛?/p>

sql澶嶅埗
SELECT 閮ㄩ棬||' '||濮撳悕||':'||TO_CHAR(缁╂晥鍒?  

锛堟墍浠ヨ鍟婏紝鏁版嵁搴撹繖鐜╂剰鍎挎瘮濂虫湅鍙嬭繕鐭儏锛屽緱椤虹潃瀹冪殑鑴炬皵鏉ワ級

鈻庝釜浜鸿鐐规椂闂?/h2>

骞茶繖琛屽叓骞翠簡锛屾€荤粨鍑轰笁鏉′繚鍛芥硶鍒欙細

1. 鈥?strong>鈥媉MySQL鐢ㄦ埛_鈥?/strong>鈥嬶細闂溂鐢–ONCAT锛岃寰楀鐞嗘暟瀛楀拰鏃ユ湡
2. 鈥?strong>鈥媉SQL Server閫夋墜_鈥?/strong>鈥嬶細鐢?鍙峰墠鍏圛SNULL锛岃鍒伴潪瀛楃涓插瓧娈电珛椹珻AST
3. 鈥?strong>鈥媉璺ㄦ暟鎹簱寮€鍙慱鈥?/strong>鈥嬶細缁熶竴鐢–ONCAT_WS锛堝鏋滄湁锛夛紝鍒嗛殧绗︽斁绗竴涓弬鏁扮渷浜?/li>

鏈€鍚庤鍙ュぇ瀹炶瘽锛氣€?strong>鈥嬪姞鍒嗛殧绗﹁繖娲诲効灏卞儚鐐掕彍鏀剧洂鈥?/strong>鈥嬧€斺€旀斁灏戜簡娌″懗锛屾斁澶氫簡榻佸緱鎱屻€傛帉鎻″ソ搴︼紝浣犵殑SQL鏌ヨ缁撴灉鎵嶈兘鏃㈢編瑙傚張涓嶅け涓撲笟锛?/p>