mysql数据库中表数据带回车,怎么去掉,急等解决! 我们知道如果表中数据带有空格,可以用trim()函数去掉,但是如果数据带有回车,该怎么去掉? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 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: 0mysql> select * from test;+---------+| str |+---------+| aaabbb || cccaaa || eb |+---------+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: 0mysql> 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 mysqldump的一个错误 can't create table 'parts' (errno:150 请教数据导入的问题 如何把MYSQL中的语句嵌入到C语言中 求一简单子查询语句 mysql 的存储过程中如何调用另外一个数据库的存储过程? 使用OleDbConnection连接MySql出错 更改用户 mysql表分区怎样设计性能才好? 求助,时间戳列转为日期再插入一列 求一HQL语句~~~~~~~!! 关于tinyint(1)类型问题
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: 0mysql> select * from test;
+---------+
| str |
+---------+
| aaa
bbb |
| ccc
aaa |
| eb |
+---------+
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: 0mysql> 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