View Full Version : Basic mySQL theory (simple question, but hard to categorize)

01-25-2007, 04:09 PM
Hi everyone. I'm trying to create a database, and although I have no problem working with mySQL, there are a few "basic theory" issues I've never dealt with before.

Basically, all I really want to know is the "standard practice" when creating databases to be used with websites. For instance, assuming that each "article" of a website has multiple paragraphs, would that mean that each paragraph would have it's own table cell?

For example, I'm envisioning creating a "text" table with all the text to be used for the site with the article name to be used as the key, i.e.:


exampleTitle exText... exText... exText... exText... exText...

If this were the case, then how would headings work? I was thinking that you would have a "headings" table, but then you would have to specify a number for how many paragraphs would go under each heading (assuming the amount of text per heading varies per article).

Of course I could just go ahead and CREATE my database in this way, but it somehow seemed kind of like re-inventing the wheel, and for all I know there is a completely standard (and ideal) way of doing this when it comes to something as common as articles for a website.

I don't necessarily need a concrete answer to my question, but does anyone out there know a good site that I can study for answers to these kinds of questions about database standards and practices?

Thanks a bunch.

01-25-2007, 04:11 PM
You would create the entire document and save it in one single row in your table. You would not break it up at all.

01-30-2007, 07:57 AM

I actually found "textile" and figured out all about it...

Thanks a bunch.