Cofa 0 Posted February 27, 2012 Report Share Posted February 27, 2012 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 Quote Link to post Share on other sites
Larry 428 Posted February 28, 2012 Report Share Posted February 28, 2012 No, that's not possible, but if you give "groups" similar prefixed names, tables associated with each other will at least be listed together. Quote Link to post Share on other sites
Cofa 0 Posted February 28, 2012 Author Report Share Posted February 28, 2012 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 Quote Link to post Share on other sites
Larry 428 Posted February 29, 2012 Report Share Posted February 29, 2012 Yes, you can use one database for different projects. There's no just official way of grouping tables together within it. Just use prefixes. Quote Link to post Share on other sites
Cofa 0 Posted February 29, 2012 Author Report Share Posted February 29, 2012 Ok Larry, Thanks once again for the help! Have a great day! Cofa 2/29/2012 Quote Link to post Share on other sites
Recommended Posts
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.