Hi, I was wondering how I would enter something like a paragraph in MySQL if you declared it as type TEXT.

So how would I enter something like:

John 3:16 (New International Version)

16" For God so loved the world that he gave his one and only Son,[a] that whoever believes in him shall not perish but have eternal life.

into a field of type TEXT?

8 Years
Discussion Span
Last Post by dickersonka

just a normal insert will work

what are you inserting from?

i'm running the instruct6ion from a text file using the source command, but why is it when I try to print the record it comes out in one line?
Can I make it print several line for that one row?

|Line 1 |
|Line 2 |

for one row?


you gotta remember formatted text is specific to the application, i'm assuming from a text file it is CR LF, but in html you will need to use <P>, when you are running the select, what are you outputting it in? query browser, web page?


I'm simply loading values into a table [via the text file SQL is reading syntax]. and the language is MySQL. when I said that the output comes out in one line I meant when runnign SQL.
How can I fix this?


first we have to figure out where the problem is at

is the data stored with the cr lf's and not outputting correctly?
or not stored with formatting (incorrectly) and therefore outputting properly?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.