mysql数据库表怎么分组_在MySQL数据库中对表进行分组

最新推荐文章于 2023-05-07 00:37:05 发布

ThoughtWorks中国

最新推荐文章于 2023-05-07 00:37:05 发布

阅读量214

点赞数

文章标签： mysql数据库表怎么分组

本文链接：https://blog.csdn.net/weixin_33254139/article/details/113114209

版权

Here's my ponder:

I've got some ER diagrams representing several thousand tables in a database. The entities represented in each of the multiple files have some associative relationship as decided by the designer. While relationships exist between entities in other files, they are not mapped. This seems common practice for diagramming databases of this size.

I was entertaining the idea of representing these groupings in a MySQL database. As SCHEMA is an alias to DATABASE in MySQL, I'm not able to find a mechanism for grouping tables within a database.

I'm wondering if anyone else has devised some creative grouping concept that they would like to share with me. Or, better yet, if MySQL supports some mechanism for grouping tables within a database, please let me know. ( I've apparently missed it in my research )

解决方案

You can use the same prefix for the tables you want to use, for example you have employees groups you make the tables emp_main and emp_Children and emp_tasks then you can have another group like items that you sell that starts all with it_