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

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • http
    Confirmed User
    • Oct 2001
    • 1811
    #1

    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 ?
    Tags: None
    • JSA Matt
      So Fucking Banned
      • Aug 2003
      • 5464
      #2
      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.

        Comment

        • woj
          <&(©¿©)&>
          • Jul 2002
          • 47880
          #3
          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

            Comment

            • pornguy
              Too lazy to set a custom title
              • Mar 2003
              • 62910
              #4
              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!

                Comment

                • stocktrader23
                  Let's do some business.
                  • Jan 2003
                  • 18781
                  #5
                  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."

                    Comment

                    • http
                      Confirmed User
                      • Oct 2001
                      • 1811
                      #6
                      Thanks guys




                      Pornguy: blow me

                        Comment

                        • chupachups
                          Confirmed User
                          • Dec 2002
                          • 6576
                          #7
                          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

                            Comment

                            • budz
                              Disruptive Innovator
                              • Sep 2003
                              • 4230
                              #8
                              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
                              C:\Code\
                              C:\Code\Run\

                                Comment

                                • mikesouth
                                  Confirmed User
                                  • Jun 2003
                                  • 6340
                                  #9
                                  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.

                                    Comment

                                    Previous template Next
                                    Working...