MySQL question: What's the difference between tables & databases?
 

I have about 5 tables for use within the same project. They are all related and I will probably use them all at once


Do I create 5 databases or 1 database with 5 tables in there?

What are the pros/cons ?

One database can store as many tables as you need. Using multiple databases can be very consuming on system resources depending on the scripts of course.

you should use one database with 5 tables...

Or just try a new career.


If nothing else, try using google to learn some of this.

Yes use google. Please don't ask webmaster questions on a webmaster board. This place exists for posting pics and fake drama only.

Thanks guys




Pornguy: blow me

What he said :1orglaugh

I agree :1orglaugh

some additional help for ya....

databases consist of tables (also called relations)

tables consist of rows (also called tuples..from tuple relational calc)

rows consist of columns also called attributes

the rules for what to put where can be found in normal forms, if you do it right and use 3rd normal form your database will hold up and be expandable with relative ease.

Do it wrong and you will find yourself having to redo it a lot sonner than you think.


you can google normal forms and SQL and get the info you need...its way beyond the scope of what I can provide here.