blocks|key|1241142|text|如果您可以使用跨多行的SQL命令，那么oedo's建议是最简单的：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1241143|INSERT+INTO+mytable+(myfield)+VALUES+('hi+this+is+some+text
and+this+is+a+linefeed.
and+another');|code-block|syntax|javascript|1241144|我只是遇到了这样一种情况:将所有的SQL语句都放在一行上比较好，所以我发现CONCAT_WS()和CHAR()的组合对我很有效。|style|CODE|1241145|INSERT+INTO+mytable+(myfield)+VALUES+(CONCAT_WS(CHAR(10+using+utf8),+'hi+this+is+some+text',+'and+this+is+a+linefeed.',+'and+another'));|1241146|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/2902888/adding-a-line-break-in-mysql-insert-into-text/2902913#2902913|1|http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_concat-ws|2|http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_char^0|J|6|0|0|0|11|B|1D|6|11|B|1|1D|6|2|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@$A|11|B|12|1|13]]|C|$]]|$1|D|3|E|5|F|7|14|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|15|8|@$A|16|B|17|K|L]|$A|18|B|19|K|L]]|9|@$A|1A|B|1B|1|1C]|$A|1D|B|1E|1|1F]]|C|$]]|$1|M|3|N|5|F|7|1G|8|@]|9|@]|C|$G|H]]|$1|O|3|-4|5|6|7|1H|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]|W|$5|R|S|T|C|$U|X]]|Y|$5|R|S|T|C|$U|Z]]]]

If you're OK with a SQL command that spreads across multiple lines, then <a href="https://stackoverflow.com/questions/2902888/adding-a-line-break-in-mysql-insert-into-text/2902913#2902913">oedo's</a> suggestion is the easiest:

<pre><code>INSERT INTO mytable (myfield) VALUES ('hi this is some text
and this is a linefeed.
and another');
</code></pre>

I just had a situation where it was preferable to have the SQL statement all on one line, so I found that a combination of <a href="http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_concat-ws" rel="noreferrer"><code>CONCAT_WS()</code></a> and <a href="http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_char" rel="noreferrer"><code>CHAR()</code></a> worked for me.

<pre><code>INSERT INTO mytable (myfield) VALUES (CONCAT_WS(CHAR(10 using utf8), 'hi this is some text', 'and this is a linefeed.', 'and another'));
</code></pre>

blocks|key|1240981|text|在实际的SQL查询中，您只需添加一个换行符|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1240982|INSERT+INTO+table+(text)+VALUES+('hi+this+is+some+text
and+this+is+a+linefeed.
and+another');|code-block|syntax|javascript|1240983|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

in an actual SQL query, you just add a newline

<pre><code>INSERT INTO table (text) VALUES ('hi this is some text
and this is a linefeed.
and another');
</code></pre>

blocks|key|1241095|text|根据记录，我想在现有数据中添加一些换行符，并且我让\n正常工作……|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1241096|示例数据：|1241097|Sentence.+Sentence.+Sentence|code-block|syntax|javascript|1241098|我做到了：|1241099|UPDATE+table+SET+field+=+REPLACE(field,+'.+',+'.\r\n')|1241100|然而，它也只适用于\r和\n。|1241101|entityMap^0|P|2|0|0|0|0|0|9|2|C|2|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|X|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|Z|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|10|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|11|8|@$9|12|A|13|B|C]|$9|14|A|15|B|C]]|D|@]|E|$]]|$1|S|3|-4|5|6|7|16|8|@]|D|@]|E|$]]]|T|$]]

For the record, I wanted to add some line breaks into existing data and I got <code>\n</code> to work ok...

Sample data:

<pre><code>Sentence. Sentence. Sentence
</code></pre>

I did:

<pre><code>UPDATE table SET field = REPLACE(field, '. ', '.\r\n')
</code></pre>

However, it also worked with just <code>\r</code> and just <code>\n</code>.

blocks|key|1026385|text|INSERT+INTO+test+VALUES('a+line\nanother+line');|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1026386|\n在这里运行得很好|unstyled|offset|length|style|CODE|1026387|entityMap^0|0|0|2|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|N|8|@$G|O|H|P|I|J]]|9|@]|A|$]]|$1|K|3|-4|5|F|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<pre><code>INSERT INTO test VALUES('a line\nanother line');
</code></pre>

<code>\n</code> just works fine here

blocks|key|1241291|text|INSERT+INTO+myTable+VALUES("First+line\r\nSecond+line\r\nThird+line");|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1241292|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>INSERT INTO myTable VALUES("First line\r\nSecond line\r\nThird line");
</code></pre>

blocks|key|1240936|text|首先，如果您希望它显示在PHP表单上，那么媒介是HTML，因此将使用<br+/>标记呈现一个新行。检查页面的源HTML+-您可能会将新行呈现为换行符，在这种情况下，您的问题只是将文本转换到web浏览器。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1240937|entityMap^0|Y|6|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

First of all, if you want it displayed on a PHP form, the medium is HTML and so a new line will be rendered with the <code>&lt;br /&gt;</code> tag. Check the source HTML of the page - you may possibly have the new line rendered just as a line break, in which case your problem is simply one of translating the text for output to a web browser.

blocks|key|1026236|text|在SQL或MySQL中，您可以使用char或chr函数在ASCII13中输入回车换行符(+\n等效项)。但正如@David+M所说，您最有可能希望HTML显示此中断，而br才是有效的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1026237|entityMap^0|H|4|M|3|19|2|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

In SQL or MySQL you can use the <code>char</code> or <code>chr</code> functions to enter in an ASCII 13 for carriage return line feed, the <code>\n</code> equivilent. But as @David M has stated, you are most likely looking to have the HTML show this break and a br is what will work.

blocks|key|1026561|text|使用<pre>标签代替html中的来显示数据库中的\n|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1026562|entityMap^0|2|5|H|3|S|2|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

use <code>&lt;pre&gt;</code> tag instead of <code>&lt;p&gt;</code> in html to show your <code>\n</code> in database

blocks|key|1241382|text|添加到@DonKirby给出的答案|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1241383|INSERT+INTO+mytable+(myfield)+VALUES+(CONCAT_WS(CHAR(10+using+utf8),+'hi+this+is+some+text',+'and+this+is+a+linefeed.',+'and+another'));|code-block|syntax|javascript|1241384|是不必要的|1241385|CHAR()函数不接受全集的utf8值。它只接受ASCII值。|offset|length|style|CODE|1241386|请参见-+https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_char|1241387|因此，用CHAR(10+USING+ASCII)代替CHAR(10+USING+utf8)会更合适。|1241388|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_char^0|0|0|0|0|6|E|4|O|5|0|5|23|0|0|4|K|Q|J|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|13|8|@$K|14|L|15|M|N]|$K|16|L|17|M|N]|$K|18|L|19|M|N]]|9|@]|A|$]]|$1|O|3|P|5|6|7|1A|8|@]|9|@$K|1B|L|1C|1|1D]]|A|$]]|$1|Q|3|R|5|6|7|1E|8|@$K|1F|L|1G|M|N]|$K|1H|L|1I|M|N]]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

Adding to the answer given @DonKirby
<pre><code>INSERT INTO mytable (myfield) VALUES (CONCAT_WS(CHAR(10 using utf8), 'hi this is some text', 'and this is a linefeed.', 'and another'));
</code></pre>
is unnecessary
The <code>CHAR()</code> function doesn't accept the full set of <code>utf8</code> values. It accepts only <code>ASCII</code> values.
See - <a href="https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_char" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_char</a>
Thus more appropriate would be to use <code>CHAR(10 USING ASCII)</code> in place of <code>CHAR(10 USING utf8)</code>

blocks|key|1026480|text|您可以简单地将所有\n替换为 标记，这样当页面显示时，它就会换行。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1026481|UPDATE+table+SET+field+=+REPLACE(field,+'\n',+' ')|code-block|syntax|javascript|1026482|entityMap^0|9|2|E|5|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

You can simply replace all <code>\n</code> with <code>&lt;br/&gt;</code> tag so that when page is displayed then it breaks line.

<pre><code>UPDATE table SET field = REPLACE(field, '\n', '&lt;br/&gt;')
</code></pre>

Could someone tell me how to add a new line in a text that I enter in a MySql table?

I tried using the <code>'\n'</code> in the line I entered with <code>INSERT INTO</code> statement but <code>'\n'</code> is shown as it is.

Actually I have created a table in MS Access with some data. MS Access adds new line with <code>'\n'</code>. I am converting MS Access table data into MySql . But when I convert, the <code>'\n'</code> is ignored and all the text is shown in one single line when I display it from MySql table on a PHP form.

Can anyone tell me how MySQL can add a new line in a text? Awaiting response, thanks!!

Adding a line break in MySQL INSERT INTO text

有人能告诉我如何在MySql表格中输入的文本中添加新行吗？我尝试在使用INSERT INTO语句输入的行中使用'\n'，但原样显示了'\n'。实际上，我已经在MS Access中创建了一个包含一些数据的表。MS Access为'\n'添加了新的行。我正在将MS Access表数据转换为MySql。但是当我转换时，'\n'被忽略，当我在PHP表单上的MySql表中显示它时，所有的文本都显示在一行中。

问在MySQL中添加换行符插入文本
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在MySQL中添加换行符插入文本EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在MySQL中添加换行符插入文本
EN