如何使用“中央列"在 phpmyadmin 中? [英] How to use "central columns" in 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.

允许使用此功能:

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

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

这篇关于如何使用“中央列"在 phpmyadmin 中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！