4 replies to this topic

[Cofa]

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]

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]

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]

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]

Ok Larry,

Thanks once again for the help!

Have a great day!

Cofa
2/29/2012