title: Adding a line break in MySQL INSERT INTO text
body: <p>Could someone tell me how to add a new line in a text that I enter in a MySql table?</p>
  
  <p>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.</p>
  
  <p>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.</p>
  
  <p>Can anyone tell me how MySQL can add a new line in a text? Awaiting response, thanks!!</p>