Databases Reference
In-Depth Information
Table abridged statistics
Moving the cursor over a table name displays comments about the table (if any), and
the number of rows currently within it as shown in the following screenshot:
Table quick-access icon
It was established that the most common action on a table must be to browse it.
Therefore, a click on the table name itself opens it in browse mode. The icon beside
each table name is a quick way to do another action on each table, and by default, it
brings us to Structure view.
The $cfg['LeftDefaultTabTable'] parameter controls this action. It has a default
value of 'tbl_structure.php' , which is the script that shows the table's structure.
Other possible values for this parameter are listed in Documentation.html . If we
prefer a setting in which a click on the table name opens it in the Structure page
and a click on the quick-access icon leads to the Browse page, we have to set
these directives:
$cfg['LeftDefaultTabTable'] = 'sql.php';
$cfg['DefaultTabTable'] = 'tbl_structure.php';
Nested display of tables within a database
MySQL's data structure is based on two levels—databases and tables. This does
not allow subdivisions of tables per project. To work by project, users must rely on
having multiple databases, but this is not always allowed by their provider. To help
them with this regard, phpMyAdmin supports a nested-levels feature based on the
naming of the table.
 
Search WWH ::




Custom Search