Databases Reference
In-Depth Information
These comments appear at various places—for example, in the export file
(see Chapter 7), on the PDF relational schema (see Chapter 15), and in the
Browse
mode:
If we do not want the comments to appear in
Browse
mode, we can set
$cfg['ShowB
rowseComments']
to
FALSE
. (It is
TRUE
by default.)
Column comments also appear as a tool tip in the
Structure
page, and column names
are underlined with dashes. To deactivate this behavior, we can set
$cfg['ShowProp
ertyComments']
to
FALSE
. (This one is also
TRUE
by default.)
Automatic Migration
Whenever phpMyAdmin detects that column comments were stored in its metadata
and that we are using MySQL 4.1.2 or a later version, it automatically migrates these
column comments to the native MySQL column comments.
Summary
In this chapter, we covered the installation of the necessary infrastructure for keeping
special metadata (data about tables), and learned how to define relations between
both InnoDB and non-InnoDB tables. We also examined the modified behavior of
phpMyAdmin when relations are present, foreign keys, getting information from the
table, the Designer feature, and column-commenting.
Search WWH ::
Custom Search