Mysql Question: Tables Of Different Projects In Database

[Cofa 0]

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

[Larry 422]

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

[Cofa 0]

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

[Larry 422]

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

[Cofa 0]

Ok Larry,

 

Thanks once again for the help!

 

Have a great day!

 

Cofa

2/29/2012