Jump to content



Photo

Mysql Question: Tables Of Different Projects In Database

myqsl

  • Please log in to reply
4 replies to this topic

#1 Cofa

Cofa

    Member

  • Members
  • PipPip
  • 49 posts
  • LocationVancouver BC

Posted 27 February 2012 - 4:14 PM

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
  • 0

#2 Larry

Larry

    Administrator/Writer

  • Administrators
  • 3,808 posts
  • LocationState College, PA (USA)

Posted 27 February 2012 - 9:51 PM

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

#3 Cofa

Cofa

    Member

  • Members
  • PipPip
  • 49 posts
  • LocationVancouver BC

Posted 28 February 2012 - 3:22 AM

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
  • 0

#4 Larry

Larry

    Administrator/Writer

  • Administrators
  • 3,808 posts
  • LocationState College, PA (USA)

Posted 29 February 2012 - 8:21 AM

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

#5 Cofa

Cofa

    Member

  • Members
  • PipPip
  • 49 posts
  • LocationVancouver BC

Posted 29 February 2012 - 1:10 PM

Ok Larry,

Thanks once again for the help!

Have a great day!

Cofa
2/29/2012
  • 0