Moreover, since MySQL 5.0.2,
a special database called information_schema appears at all times in the
database list. It contains a set of views describing the metadata visible for
the logged-in user.
We may have the right to create one, as explained in Chapter 4.
Light Mode
The left panel can be shown in two ways: the Light mode and the Full mode. The
Light mode is used by default, defined by a TRUE value in $cfg['LeftFrameLight'].
This mode shows a drop-down list of the available databases, and only tables of the
currently chosen database are displayed. It is more efficient than Full Mode;
the reason is explained in the Full Mode section.
Interface Overview
[ 52 ]
Here we have chosen the mysql database:
Clicking on the database name opens the right panel in the Database view, and
clicking on a table name opens the right panel in the Table view. (See the Right Panel
section for details.)
Tree Display of Database Names
A user might be allowed to work on a single database, for example marc. Some
system administrators offer a more flexible scheme by allowing user marc to create
many databases, provided their names all start with marc??”like marc_airline
and marc_car. In this situation, the left panel can be set to display a tree of these
database names.
Chapter 3
[ 53 ]
This feature is currently offered only in light mode and is controlled by
these parameters:
$cfg['LeftFrameDBTree'] = TRUE;
$cfg['LeftFrameDBSeparator'] = '_';
The default value of TRUE in $cfg['LeftFrameDBTree'] ensures that this feature is
activated.
Pages:
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78