如何使用“中心柱"在 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'] (eg pma__central_columns)
可以通过将配置设置为 false 来禁用此功能.
This feature can be disabled by setting the configuration to false.
相关文章