Cofa Posted February 27, 2012 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 Link to comment Share on other sites More sharing options...
Larry Posted February 28, 2012 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. Link to comment Share on other sites More sharing options...
Cofa Posted February 28, 2012 Author 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 Link to comment Share on other sites More sharing options...
Larry Posted February 29, 2012 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. Link to comment Share on other sites More sharing options...
Cofa Posted February 29, 2012 Author Share Posted February 29, 2012 Ok Larry, Thanks once again for the help! Have a great day! Cofa 2/29/2012 Link to comment Share on other sites More sharing options...
Recommended Posts