Databases Reference
In-Depth Information
Quick-Browsing a Table
The small icon beside each table name is a quick way to browse the table's rows. It
opens the right panel in the Table view, browsing the first page of data from the table.
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:
Search WWH ::
Custom Search