Database Reference
In-Depth Information
Table quick-access icon
Starting with version 3.0, 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 small 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 showing the table's structure.
Other possible values for this parameter are listed in Documentation.html .
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, a feature often requested by MySQL users.
They must rely on having multiple databases, but this is not always allowed by their
provider. To help them with this regard, phpMyAdmin introduces a nested-levels
feature, based on the table naming.
Let's say we have access to the db1 database, and we want to represent two projects,
marketing and payroll . Using a special separator (by default a double underscore)
between the project name and the table name, we create the payroll__employees and
payroll__jobs tables , achieving a visually interesting effect:
This feature is parameterized with $cfg['LeftFrameTableSeparator'] (set
here to '__' ) to choose the characters that will mark each level change, and
$cfg['LeftFrameTableLevel'] (set here to '1' ) for the number of sub-levels.
 
Search WWH ::




Custom Search