MySQL question: What's the difference between tables & databases? - GoFuckYourself.com

http · 09-25-2004, 08:27 PM

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 ?

JSA Matt · 09-25-2004, 08:28 PM

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.

woj · 09-25-2004, 08:29 PM

you should use one database with 5 tables...

pornguy · 09-25-2004, 08:31 PM

Or just try a new career.

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

stocktrader23 · 09-25-2004, 08:32 PM

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

http · 09-25-2004, 08:36 PM

Thanks guys

Pornguy: blow me

chupachups · 09-25-2004, 08:37 PM

Quote:

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

What he said

budz · 09-25-2004, 08:54 PM

Quote:

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

I agree

mikesouth · 09-25-2004, 09:04 PM

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.

09-25-2004, 08:27 PM	#1
http Confirmed User Join Date: Oct 2001 Posts: 1,811	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 ?

09-25-2004, 08:29 PM	#3
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	you should use one database with 5 tables... __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

09-25-2004, 08:31 PM	#4
pornguy Too lazy to set a custom title Industry Role: Join Date: Mar 2003 Location: Homeless Posts: 62,911	Or just try a new career. If nothing else, try using google to learn some of this. __________________ PornGuy skype me pornguy_epic AmateurDough The Hottes Shemales online! TChicks.com \| Angeles Cid \| Mariana Cordoba \| MAILERS WELCOME!

09-25-2004, 08:32 PM	#5
stocktrader23 Let's do some business. Industry Role: Join Date: Jan 2003 Location: The dirty south. Posts: 18,781	Yes use google. Please don't ask webmaster questions on a webmaster board. This place exists for posting pics and fake drama only. __________________ Hands Free Adult - Join Once, Earn For Life "I try to make a habit of bouncing my eyes up to the face of a beautiful woman, and often repeat “not mine” in my head or even verbally. She’s not mine. God has her set aside. She’s not mine. She’s His little girl, and she needs me to fight for her by keeping my eyes where they should be."

09-25-2004, 09:04 PM	#9
mikesouth Confirmed User Industry Role: Join Date: Jun 2003 Location: My High Horse Posts: 6,334	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. __________________ Mike South It's No wonder I took up drugs and alcohol, it's the only way I could dumb myself down enough to cope with the morons in this biz.

09-25-2004, 08:28 PM	#2
JSA Matt So Fucking Banned Join Date: Aug 2003 Location: San Diego, CA Posts: 5,464	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.

09-25-2004, 08:36 PM	#6
http Confirmed User Join Date: Oct 2001 Posts: 1,811	Thanks guys Pornguy: blow me