Databases Reference
In-Depth Information
•
•
Define the relations of the current table to other tables
Choose the display field
Since our goal here is to create a relation between the
topics
table (which contains
the author ID) and the
authors
table (which describes each author by an ID), we start
on the Table view for the
topics
table and click the
Relation view
link.
Internal phpMyAdmin Relations
Since the
topics
table is in MyISAM format, we see the following screen (otherwise,
the display would be different, as explained in the
InnoDB Relations
section later):
This screen allows us to create
Internal relations
(stored in the
pma_relation
table),
because MySQL itself does not have any relational notion for MyISAM tables.
The double-dash (
--
) characters indicate that there are
no
relations (links) to any
foreign table.
Defining the Relation
We can relate each field of the
topics
table to a field in another table (or in the same
table, because self-referencing relations are sometimes necessary). The interface finds
the unique and non-unique keys in all tables of the same database and presents the
Search WWH ::
Custom Search