Geek asks and answers

Best way to store multiple rows of data in MySQL?

I am looking to store several rows of data in MySQL (or your choice), an example is a poem. I would not know how many lines this can be, and I have to keep my structure intact, so when I show it to my end users on the site, it is formatted correctly.

I could store from 100 characters to 100,000. I would rather be shy to use plain text if someone does not help me find a simpler method.

+5
source share
2 answers

If you save the text in a simple format, such as Markdown , you can display it as HTML using any number of converted libraries.

MySQL. 1 TEXT 64 LONG TEXT .

VARCHAR MySQL, , , , .

+1

. , html-, <br/>, . sql .

, , mysql mysql (, ).

+1

More articles:


All Articles