如何使用“中心柱"在 phpmyadmin 中?

2022-01-20 00:00:00 foreign-keys mysql phpmyadmin

PMA 具有添加中心列的工具.据我了解,它与外国约束一起使用.我有两个表:TableATableB.

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_Aname_of_A_value...

TableB 的结构:id_of_Bforeign_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.

要允许使用此功能:

  1. 设置 $cfg['Servers'][$i]['pmadb'] 和 phpMyAdmin 配置存储

  1. 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.

相关文章