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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×