鈥?strong>鈥嬪搸锛屼綘鏄笉鏄粡甯搁亣鍒拌繖绉嶆儏鍐碉紵鈥?/strong>鈥?br/> 鏁版嵁搴撻噷瀛樼潃鐢ㄦ埛鐨勫銆佸悕銆佺數璇濆彿鐮侊紝浣嗘槸鑰佹澘闈炶浣犳妸杩欎笁涓瓧娈靛悎骞舵垚"寮犱笁锛?3812345678锛?鐨勬牸寮忥紵鎴栬€呴渶瑕佹妸璁㈠崟鍙峰拰鍟嗗搧鍚嶇О鎷兼垚涓€鏉″畬鏁翠俊鎭紵杩欐椂鍊欒鏄笉浼氬瓧绗︿覆鎷兼帴锛屾槸涓嶆槸鎰熻鍍忔嬁绛峰瓙澶规堡鍦嗏€斺€斾娇涓嶄笂鍔插効锛?/p>

鍒厡锛佷粖澶╁挶浠氨鐢ㄥぇ鐧借瘽鑱婅亰SQL閲屸€?strong>鈥嬫渶甯哥敤銆佹渶瀹炵敤鈥?/strong>鈥嬬殑涓夌瀛楃涓叉嫾鎺ユ柟娉曪紝淇濆噯浣犵湅瀹屽氨鑳戒笂鎵嬪共娲伙紒

涓€銆佸厛鎼炴噦鍩虹锛氬瓧绗︿覆鎷兼帴鍒板簳鏈夊暐鐢紵

涓句釜鏍楀瓙馃尠锛屼綘鎵嬪ご鏈夊紶鐢ㄦ埛琛細

鑰佹澘瑕佷綘瀵煎嚭涓€鍒楁暟鎹紝鏍煎紡鏄?濮撳悕+鐢佃瘽"锛屾瘮濡?寮犱笁锛?3812345678锛?銆傝繖鏃跺€欎綘瑕佹槸鎵嬪姩澶嶅埗绮樿创锛?00鏉℃暟鎹緱鍋氬埌鏄庡ぉ鏃╀笂鍚э紵鈥?strong>鈥嬭繖鏃跺€欏瓧绗︿覆鎷兼帴灏辨槸浣犵殑鏁戝懡绋昏崏锛佲€?/strong>鈥?/p>

浜屻€佷笁澶х鍣ㄧ櫥鍦猴細CONCAT銆?銆亅|鎬庝箞閫夛紵

鈻?绗竴鎶婃鍣細CONCAT鍑芥暟锛圡ySQL閫夋墜蹇呯湅锛?/h3>

鈥?strong>鈥嬮€傜敤鍦烘櫙锛氣€?/strong>鈥?褰撳瓧娈甸噷鏈塏ULL鍊兼椂锛岃繕鑳界户缁嫾鎺ヤ笉鎶ラ敊

sql澶嶅埗
SELECT CONCAT(濮? 鍚? '(', 鐢佃瘽, ')') AS 鐢ㄦ埛淇℃伅 FROM 鐢ㄦ埛琛?

鈥?strong>鈥嬮噸鐐规敞鎰忥細鈥?/strong>鈥?/p>

• 鍦∕ySQL閲岀敤杩欎釜鏈€绋冲綋锛屽氨绠楁煇涓瓧娈垫槸NULL锛屼篃浼氳嚜鍔ㄨ浆鎴愮┖瀛楃涓茬户缁嫾鎺?/li>
• 瑕佹槸瀛楁澶锛屽缓璁瘡琛屾崲琛屽啓锛屾瘮濡傦細

sql澶嶅埗
CONCAT(
    濮?
    鍚?
    '(',
    鐢佃瘽,
    ')'
)

锛堣繖鏍峰啓浠ｇ爜鐪嬭捣鏉ユ竻鐖斤紝缁存姢璧锋潵涔熸柟渚垮鍚э紵锛?/p>

---

鈻?绗簩鎶婃鍣細鍔犲彿+锛圫QL Server涓撶敤锛?/h3>

鈥?strong>鈥嬮€傜敤鍦烘櫙锛氣€?/strong>鈥?鍦ㄥ井杞郴鏁版嵁搴撻噷鑰嶅竻蹇呭

sql澶嶅埗
SELECT 濮?+ 鍚?+ '(' + 鐢佃瘽 + ')' AS 鐢ㄦ埛淇℃伅 FROM 鐢ㄦ埛琛?

鈥?strong>鈥嬩絾鏄紒杩欓噷鏈変釜澶у潙锛氣€?/strong>鈥?br/> 濡傛灉瀛楁閲屾湁NULL鍊硷紝鏁翠釜鎷兼帴缁撴灉鐩存帴鍙楴ULL锛佽繖鏃跺€欏氨闇€瑕佺敤ISNULL鍑芥暟鏉ュ～鍧戯細

sql澶嶅埗
SELECT 
    ISNULL(濮?'') + 
    ISNULL(鍚?'') + 
    '(' + 
    ISNULL(鐢佃瘽,'鏈煡') + 
    ')' 
FROM 鐢ㄦ埛琛?

---

鈻?绗笁鎶婃鍣細鍙岀珫绾縷|锛圤racle/PostgreSQL鐜╁涓撳睘锛?/h3>

鈥?strong>鈥嬮€傜敤鍦烘櫙锛氣€?/strong>鈥?鍐欎唬鐮佹椂鎯宠涓猉锛屾樉寰楄嚜宸卞緢鎳傝

sql澶嶅埗
SELECT 濮?|| 鍚?|| '(' || 鐢佃瘽 || ')' AS 鐢ㄦ埛淇℃伅 FROM 鐢ㄦ埛琛?

鈥?strong>鈥嬬壒鍒彁绀猴細鈥?/strong>鈥?/p>

• 鍦∣racle閲岀敤杩欎釜鏈€椤烘墜锛屼絾鍜孲QL Server鐨?涓€鏍凤紝閬囧埌NULL浼氱炕杞?/li>
• PostgreSQL姣旇緝璐村績锛孨ULL浼氬綋绌哄瓧绗︿覆澶勭悊

---

涓夈€佺湡浜哄疄鎴樻渚嬶細閫夐敊鏂规硶鏈夊鎯紵

鈥?strong>鈥嬫晠浜嬫椂闂村埌锛佲€?/strong>鈥?鎴戞湁涓湅鍙嬶紙鐪熺殑涓嶆槸鎴戣嚜宸憋級鍦⊿QL Server閲岃繖涔堝啓锛?/p>

sql澶嶅埗
SELECT 濮撳悕 + '浠婂勾' + 骞撮緞 + '宀? FROM 鐢ㄦ埛琛?/code>

sql澶嶅埗
SELECT 濮撳悕 + '浠婂勾' + CONVERT(VARCHAR, 骞撮緞) + '宀? FROM 鐢ㄦ埛琛?/code>

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

-- SQL Server
SELECT 鐪佷唤 + '-' + 鍩庡競 + '-' + 鍖哄煙

-- Oracle
SELECT 鐪佷唤 || '-' || 鍩庡競 || '-' || 鍖哄煙