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?
Jump to Postjust a normal insert will work
what are you inserting from?
Jump to Postyou 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?
just a normal insert will work
what are you inserting from?
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?
Like:
+-----------------------+
|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?
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.