mysqlÊý¾Ý¿âÖбíÊý¾Ý´ø»Ø³µ£¬Ôõôȥµô£¬¼±µÈ½â¾ö£¡

ÎÒÃÇÖªµÀÈç¹û±íÖÐÊý¾Ý´øÓпոñ£¬¿ÉÒÔÓÃtrim()º¯ÊýÈ¥µô£¬µ«ÊÇÈç¹ûÊý¾Ý´øÓлسµ£¬¸ÃÔõôȥµô£¿

---

replace

---

replace(xxxx,'\n','')

---

SQL code:

mysql> insert into test values('aaa\nbbb'),('ccc\naaa'),('e\n\nb');
Query OK, 3 rows affected (0.02 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> select * from test;
+---------+
| str |
+---------+
| aaa
bbb |
| ccc
aaa |
| e

b |
+---------+
3 rows in set (0.02 sec)

mysql> update test set str=replace(str,'\n','');
Query OK, 3 rows affected (0.05 sec)
Rows matched: 3 Changed: 3 Warnings: 0

mysql> select * from test;
+--------+
| str |
+--------+
| aaabbb |
| cccaaa |
| eb |
+--------+
3 rows in set (0.00 sec)

---

·Ç³£¸Ðл£¬°´ÕÕÂ¥ÉÏ·½·¨ÎÊÌâÒѽâ¾ö£¡

---

µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html

---

Õý½â¡£

ÒýÓÃ

replace(xxxx,'\n','')