如何使用“中心柱”在phpmyadmin? [英] How to use "central columns" in phpmyadmin?
问题描述
TableA
和 TableB
。 TableA的结构:
id_of_A
, name_of_A_value
, $ b $
TableB
的结构: id_of_B
, foreign_id_of_A
, ...
和 foreign_id_of_A
至 A表
。 id_of_A
。
在将新行插入 TableB
时,选择所需的 foreign_id_of_A
非常困难,因为只有值的 id_of_A
是可见的。中央的列可以帮助我解决这个问题吗?中央列如何工作?
中央列
您可以按照您的要求将列添加/删除列表。中央列表中的这些列将可用于在为表创建新列或自行创建表时使用。您可以从中央列表中选择一个列,同时创建一个新列,这样可以避免再次写同一列定义,或者为相似列写入不同的名称。
允许使用这个功能:
$ b
-
设置
$ cfg ['Servers'] [$ i] ['pmadb']
和phpMyAdmin配置
存储 -
将表名放在
$ cfg ['Servers'] [$ i] ['central_columns']
(例如pma__central_columns)
可以通过将配置设置为false来禁用此功能。
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
.
Structure of TableA
: id_of_A
, name_of_A_value
, ...
Structure of TableB
: id_of_B
, foreign_id_of_A
,...
and foreign constraint from foreign_id_of_A
to A-table
.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?
Central Column
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.
To allow the usage of this functionality:
set up
$cfg['Servers'][$i]['pmadb']
and the phpMyAdmin configuration storageput the table name in
$cfg['Servers'][$i]['central_columns']
(e.g. pma__central_columns)
This feature can be disabled by setting the configuration to false.
这篇关于如何使用“中心柱”在phpmyadmin?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!