Databases Reference
In-Depth Information
These comments will be shown at appropriate places, for example, in the
navigation panel, next to the table name in the
Table
view, and in the export file.
The following screenshot shows what the navigation panel looks like when the
$cfg['ShowTooltip']
parameter is set to its default value of
TRUE
:
The default value (
FALSE
) of
$cfg['ShowTooltipAliasDB']
and
$cfg['ShowTooltipAliasTB']
produces the behavior we saw earlier—the true
database and table names are displayed in the navigation panel and in the
Database
view for the
Structure
page. Comments appear as a tooltip (when the cursor is
hovered over a database or table name). If one of these parameters is set to
TRUE
,
the behavior is reversed—showing the comment by default and the true name as a
tooltip. This is convenient when the real table names are not meaningful.
There is another possibility for
$cfg['ShowTooltipAliasTB']
—the
'nested'
value. Here is what happens if we use this feature:
• The true table name is displayed in the navigation panel
• The table comment (for example,
project__
) is interpreted as the project
name and is displayed as it is (refer to the
Nested
display
of
tables
within
a
database
section in
Chapter
3
)
Table order
When we browse
a table, or execute a statement such as
SELECT
*
from
book
without
specifying a sort order, MySQL uses the order in which the rows are physically stored.
This table order can be changed with the
Alter
table
order
by
dialog. We can choose
any column and the table will be reordered once on this column. We choose
author_id
in the example, and after we click on
Go
, the table gets sorted on this column.
Reordering is convenient if we know that we will be retrieving rows in this order
most of the time. Moreover, if we use an
ORDER
BY
clause later on, and the table is
already physically sorted on this column, we might get better performance.
Search WWH ::
Custom Search