使用phpMyAdmin中的文件夹组织数据库 [英] Organizing a database using folders in phpMyAdmin

问题描述

现在，我在phpMyAdmin中有一个数据库，并且在屏幕的旁边，它显示了数据库名称以及该数据库中的表的列表.如果只有几个表就可以了，但是当有几十个表时，很难找到我要编辑的表.我曾考虑过创建另一个数据库以使其更易于组织，但是随后我将不得不使用不同的数据库名称和该数据库的不同用户登录名进行连接，而我只是想如果可以在数据库中创建文件夹或类似的东西，我已经必须组织我的表了.我想知道是否有可能这样的事情，或者有人知道任何解决此问题的方法.

Right now I have a database in phpMyAdmin, and off the the side of the screen, it shows the database name, and a list of tables inside the database. It's fine if it's only a couple of tables, but when there's dozens of tables, it gets hard to find the tables I want to edit. I've thought about creating another database to make it easier to organize, but then I'll have to connect using the different database's name and a different user login for the database, and I just thought how much easier would it be if I can make folders or something similar inside the database I already have to organize my tables. I'm wondering if something like this is possible, or anyone know any work-around this issue.

推荐答案

好吧，您不能在数据库中创建数据库(或文件夹).这只是MySQL无法做到的.

Well, you can't create a database (or folders) within a database; that's just not something MySQL is able to do.

phpMyAdmin具有分组功能，可以帮助您解决问题.默认情况下，带有前缀_(单个下划线)的数据库将被分组在一起，带有__(两个下划线)的表也将被分组.

phpMyAdmin has a grouping feature that may help your situation. By default, databases with a prefix followed by _ (a single underscore) will be grouped together, as will tables with __ (two underscores).

这是一个在分组时最终看起来如何的示例:

Here's an example of how this ends up looking when grouped:

数据库:

表格:

如果您能够重命名某些表，则可以利用分组功能使phpMyAdmin的显示更加易于管理.当然，这不会改变其他工具显示表列表的方式.

If you're able to rename some of your tables, you'll be able to take advantage of the grouping feature to make the phpMyAdmin display a bit more manageable. Of course, this won't change the way other tools display the table list.

配置指令$cfg['NavigationTreeDbSeparator']和$cfg['NavigationTreeTableSeparator']控制使用的分隔符.相关文档始于 http://docs.phpmyadmin.net/en/latest/config.html#cfg_NavigationTreeEnableGrouping ，并包括接下来的几个订单项.

The configuration directives $cfg['NavigationTreeDbSeparator'] and $cfg['NavigationTreeTableSeparator'] control the separator used. The relevant documentation starts at http://docs.phpmyadmin.net/en/latest/config.html#cfg_NavigationTreeEnableGrouping and includes the next few line items.

这篇关于使用phpMyAdmin中的文件夹组织数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！