Adding a Line Break in mySQL INSERT INTO text
- by james
Hi
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 !!