1ï¼é¦å
æ¯å»é¤ç©ºæ ¼å¨è¿è¡æ¯è¾ï¼æ¯å¦ï¼æå§åä¸çææç©ºæ ¼å»é¤ï¼ï¼
Update table_name set xm=replace(xm , ' ') ;
å¦æè¦æ¥æ¾åªäºè®°å½å«æ' 'ï¼å¯ç¨ç¸å
³çè¯å¥æ¥æ¾ã
ç¶åå¯è¿è¡æ¯è¾ã
2ï¼ä½æ¯æ们å¯è½ä¼åç°ï¼æäºå§åä¸é´ææ«å°¾è¿æç±»ä¼¼ç©ºæ ¼çå符没被å»æï¼ä½å®ä»¬æ¾ç¶å·²ç»ä¸æ¯ä¸è¬çç©ºæ ¼äºï¼é£ä¹æçæ¯Tabå¥ä½æªãäºæ¯åç
§ç½ä¸è¯´çå»æTABé®çåæ³æ¥å¤çï¼ç¨chr(9)æ¥æ¿ä»£ç©ºæ ¼é®ï¼TABé®çASCIIå¼ä¸º9ï¼ãå
åä¸æ¡å¸¦æç±»ç©ºæ ¼å符çè®°å½æ¥åå®éªï¼
SELECT replace(xm, chr(9) ) from table_name where bh=âxxxâ;
ç¨è¿ä¸ªåæ³ä¼å»æä¸äºçæ£çTabé®ç©ºæ ¼ï¼ç¶åéåæ¹éæ´æ°çåæ³ã
3ï¼ä½æéå°çæ
åµæ²¡æè¿ä¹å¹¸è¿ï¼æ²¡è½å»æç±»ç©ºæ ¼é®ãæä¹åå¢ï¼æå³å®å°è¯å
åå¾è¿ä¸ªç±»ç©ºæ ¼é®çASCIIç å¼ï¼ç¶ååç¨chr(ASCIIç å¼)çæ¹æ³æ¥å¤çã
â ï¼åå¾å«ç±»ç©ºæ ¼é®æ´ä¸ªå符串çé¿åº¦ length()ï¼ä»èç¡®å®åºç±»ç©ºæ ¼é®å¨å符串ä¸çèµ·å§ä½ç½®ãç±»ç©ºæ ¼é®çé¿åº¦ã
â¡ï¼æ±åºç±»ç©ºæ ¼é®çASCIIç å¼ï¼ascii(substr(xm,n,m)); nä¸ºç±»ç©ºæ ¼é®çèµ·å§ä½ç½®ï¼m为é¿åº¦ã
â¢ï¼SELECT replace(xm, chr(第â¡æ¥æ±å¾çASCIIç å¼) ) from table_name where bh=âxxxâ;
é®é¢å¾ä»¥è§£å³ãä½æåç°ï¼ä¸è¿°ç¬¬â¡æ¥æ±å¾çASCIIç å¼ä¸º41377ï¼è¿åºè¯¥æ¯ä¸ä¸ªæ±åçASCIIç å¼ï¼çèµ·æ¥ååç©ºæ ¼ï¼äºæ¯ææçï¼ä¼ä¸ä¼æ¯ä¸æç¶æä¸çç©ºæ ¼é®ãTABé®ï¼å°è¯ä¹ååç°ä¸æ¯ãæåæçï¼æ¯ä¸æ¯å
¨è§ãåè§çåºå«ï¼å 为æ们ä¸è¬è¾å
¥å符ï¼æ¯å¨åè§ä¸è¾å
¥çãææç
§ç¬¬ä¸æ¥â1ï¼é¦å
æ¯å»é¤ç©ºæ ¼å¨è¿è¡æ¯è¾â¦â¦âå°è¯ï¼è¾å
¥å
¨è§ä¸çç©ºæ ¼ï¼è¿è¡æ¥æ¾ï¼ç»ææååºç°ï¼åæ¥æææªåé¤æçç±»ç©ºæ ¼ï¼æ¯å
¨è§ç¶æä¸è¾å
¥çç©ºæ ¼ï¼å¹¶æ¥è¯å®äºå
¨è§ä¸è¾å
¥çç©ºæ ¼ï¼å
¶ASCIIç å¼ä¸º41377ã
温馨提示:答案为网友推荐,仅供参考