如何从列中删除回车符和换行符? [英] How to remove carriage returns and line feeds from a column?

问题描述

我正在尝试从我从csv文件导入的列中删除回车符和换行符.
我正在使用代码:

I'm trying to remove carriage returns and line feeds from a column I imported from a csv file.
I'm using the code:

SELECT replace(replace(column,CHAR(13),''),CHAR(10),'')
FROM table

它可以正确找到所有CR和LF，但不会更新数据库.

It correctly finds all the CR and LF, but it doesn't update the database.

推荐答案

您的查询从名为TABLE的表中检索所有已替换列的行.

Your query retrieve from your table named TABLE all rows with the column replaced.

关于UPDATE数据库，您必须以这种方式使用UPDATE命令:

About UPDATE your database you must use UPDATE command in this way:

UPDATE table SET column = replace(replace(column,CHAR(13),''),CHAR(10),'')

如果您要对有关某些条件的满足条件进行更新，则必须添加WHERE子句.

If you want condition the UPDATE about the satisfaction of some conditions, so you must add the WHERE clause.

例如

UPDATE table SET column = replace(replace(column,CHAR(13),''),CHAR(10),'')
WHERE column_2 = 'XXX'

这篇关于如何从列中删除回车符和换行符?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！