如何使用“中央列"在 phpmyadmin 中?
PMA 具有用于添加中央列的工具.据我了解，它与外部约束一起使用.我有两个表:TableA 和 TableB.
PMA has the tools for adding the central columns. As far as I understand, it's used with foreign constraints. I have two tables: TableA and TableB.
TableA 的结构:id_of_A、name_of_A_value、...
TableB 的结构:id_of_B、foreign_id_of_A、... 和来自 foreign_id_of_A 的外部约束 到 A-table.id_of_A.
Structure of TableB: id_of_B, foreign_id_of_A,... and foreign constraint from foreign_id_of_A to A-table.id_of_A.
并且在将新行插入到TableB中时很难选择需要的foreign_id_of_A，因为只有id_of_A的值是可见的.中心柱能帮我解决这个问题吗?中心柱如何工作?
And it's very difficult to select needed foreign_id_of_A while insert new row into TableB because only value of id_of_A is visible. Could central columns help me with this problem? How central column works?
推荐答案
中央栏目
您可以根据需要在列表中添加/删除列.当您为表创建新列或创建表本身时，可以使用中央列表中的这些列.您可以在创建新列时从中央列表中选择一列，这样您就不必重新编写相同的列定义或为相似的列编写不同的名称.
You can add/remove columns to the list as per your requirement. These columns in the central list will be available to use while you create a new column for a table or create a table itself. You can select a column from central list while creating a new column, it will save you from writing the same column definition over again or from writing different names for similar column.
允许使用此功能:
设置
$cfg['Servers'][$i]['pmadb']和 phpMyAdmin 配置存储
set up
$cfg['Servers'][$i]['pmadb']and the phpMyAdmin configuration storage
把表名放在$cfg['Servers'][$i]['central_columns'] (例如pma__central_columns)
可以通过将配置设置为 false 来禁用此功能.
This feature can be disabled by setting the configuration to false.
相关文章