Jump to content
Larry Ullman's Book Forums
Sign in to follow this  
Cofa

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?

 

Thanks,

Cofa

2/27/2012

Share this post


Link to post
Share on other sites

No, that's not possible, but if you give "groups" similar prefixed names, tables associated with each other will at least be listed together.

Share this post


Link to post
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?

 

Regards,

Cofa

2/27/2012

Share this post


Link to post
Share on other sites

Yes, you can use one database for different projects. There's no just official way of grouping tables together within it. Just use prefixes.

Share this post


Link to post
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.

Guest
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.

Loading...
Sign in to follow this  

×
×
  • Create New...