2

Is it possible to group tables in mysql?

That is, say i'm using PHP My Admin, and all the tables are listed on the left, can I have them in some sort of folder structure or group?

I'm fairly sure this isn't possible.... and if it is, i'm going to guess that it's an application layer thing, ie something that a particular app will allow you to do.

So if that is the case, does anyone know the name of such an application with this feature?

Thanks

Improve this question
2
  • 1
    Is this just a cosmetic thing or do you want some type of data relationship between the tables - not sure I understand what you are attempting to do?
    – Linker3000
    Jan 26, 2011 at 23:19
  • It's just a cosmetic thing, yes
    – Jason
    Jan 27, 2011 at 4:55

3 Answers 3

Reset to default
2

AFAIK, There isn't a way to do this.

Improve this answer
1
  • I think OP ask for grouping for the purpose of visualization. Shall we create separate database for each "group" and work with sub-databases and use some sort of script to sync table with main database? Like crm_party (all user & org tables), crm roles, crm_contacts, etc. We can also duplicate same table across multiple sub-databases. Do you think it is worth the efforts?
    – SenG
    Oct 9, 2016 at 14:07
1

Navicat for MySQL allows you to do this - although I think it just changes the way Navicat displays the tables, not the underlying database at all.

Improve this answer
0

In phpMyAdmin I think it's possible if you're giving some tables the same prefix (eg jason_users & jason_posts)

see http://sourceforge.net/projects/phpmyadmin/forums/forum/72909/topic/3777476

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .