Database Reference
In-Depth Information
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 left panel and in the Database view
for the
Structure
subpage. Comments appear when the mouse pointer is moved
over a table name. If one of these parameters is set to
TRUE
, the corresponding item
(database names for
DB
and table names for
TB
) will be shown as the tooltip instead
of the names. This time, the mouseover shows the true name for the item. 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 left panel
•
The table comment (for example
project__
) is interpreted as the project
name and is displayed as it is (see 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 field and the table will be reordered once on this field.
We choose
author_id
in the example, and after we click
Go
, the table gets sorted
on this field.
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 field, the performance should be higher.
This default ordering will last as long as there are no changes in the table
(no insertions, deletions, or updates). This is why phpMyAdmin shows the
(singly)
warning.
Search WWH ::
Custom Search