Adding a line break in MySQL INSERT INTO text

Question

Could someone tell me how to add a new line in a text that I enter in a MySql table   I tried using the   n  in the line I entered with INSERT INTO statement but   n  is shown as it is   Actually I have created a table in MS Access with some data  MS Access adds new line with   n    I am converting MS Access table data into MySql   But when I convert  the   n  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

User · Answer

MySQL can record linebreaks just fine in most cases, but the problem is, you need <br /> tags in the actual string for your browser to show the breaks. Since you mentioned PHP, you can use the nl2br() function to convert a linebreak character ("\n") into HTML <br /> tag.

Just use it like this:

<?php
echo nl2br("Hello, World!\n I hate you so much");
?>

Output (in HTML):

Hello, World!<br>I hate you so much

Here's a link to the manual: http://php.net/manual/en/function.nl2br.php

User · Answer

INSERT INTO test VALUES  a line nanother line       n just works fine here

User · Answer

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  lt br   gt  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

User · Answer

You have to replace  n with  lt br  gt  before inset into database    data   str replace   n     lt br  gt     data    In this case in database table you will see  lt br  gt  instead of new line   e g   First LineSecond Line  will look like    First Line lt br  gt Second Line Another way to view data with new line  First read data from database  And then replace  n with  lt br  gt  e g     echo  data   data   str replace   n     lt br  gt     data   echo   lt br  gt  lt br  gt      data   output   First Line Second LineFirst LineSecond Line   You will find details about function str replace   here  http   php net manual en function str-replace php

User · Answer

If you re OK with a SQL command that spreads across multiple lines  then oedo s suggestion is the easiest   INSERT INTO mytable  myfield  VALUES   hi this is some text and this is a linefeed  and another      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 CONCAT WS   and CHAR   worked for me   INSERT INTO mytable  myfield  VALUES  CONCAT WS CHAR 10 using utf8    hi this is some text    and this is a linefeed     and another

User · Answer

In SQL or MySQL you can use the char or chr functions to enter in an ASCII 13 for carriage return line feed  the  n 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

User · Answer

For the record  I wanted to add some line breaks into existing data and I got  n to work ok     Sample data   Sentence  Sentence  Sentence   I did   UPDATE table SET field   REPLACE field           r n     However  it also worked with just  r and just  n

User · Answer

You can simply replace all  n with  lt br  gt  tag so that when page is displayed then it breaks line   UPDATE table SET field   REPLACE field    n     lt br  gt

User · Answer

INSERT INTO myTable VALUES  First line r nSecond line r nThird line

User · Answer

in an actual SQL query  you just add a newline  INSERT INTO table  text  VALUES   hi this is some text and this is a linefeed  and another

[mysql] Adding a line break in MySQL INSERT INTO text

Examples related to mysql

Examples related to newline

Examples related to insert-into