Jump to content
Larry Ullman's Book Forums

Mysql Question: Tables Of Different Projects In Database

Recommended Posts

My web host allows 3 databases for my host account and I understand I can create as many as possible tables per database (except for any limitation with MySQL that I don't know).


My question is: Can I create different *groups* of tables in just one database, with each *group* being for an individual project that is not related to other projects?





Link to comment
Share on other sites

Thank you for replying; but I am confused...


Your "no" - does it mean I cannot use one database for different projects? But your "but..." confuses me.


Say I have a project for a "tour interest group" that may require 3 tables, and I have another project that deals with my "business clients management" that requires 10 tables.


Can I create all of these tables in just one database, while

tables for the "tour interest group" will have names prefixed with "tour-"; and

tables for "business clients management" will have names prefixed with "buz-"?


Or must I use two databases to hold the two groups of tables separately?





Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...