How can I organize a glut of mysql tables? [closed]

Closed. This question needs details or clarity. It is not currently accepting answers.

---

Want to improve this question? Add details and clarify the problem by editing this post.

Closed 5 years ago.

开发者_如何学Go Improve this question

Our development database now has 263 tables. During development we only work with a few. Is there anyway to organize all the tables into something like folders?

---

There is no way to organize tables hierarchically that is meaningful to MySQL.

As others have noted, you can maintain separate schemas (in MySQL, databases), or you can develop and use a table naming structure that organizes your tables in a way that is meaningful to users (but is still not meaningful to MySQL).

---

The only thing that occurs to me is to use different databases for different sets of tables. See CREATE DATABASE

---

I don't believe there is a way to organize tables other than to move them into other dbs. What you could do is prefix the ones you use frequently so they are always at the top (this only works though if you have defined constants for your table names for just such an occasion so you don't have to trudge through your source code changing every instance it is called).