Databases Reference
In-Depth Information
phpMyAdmin offers to define only one display field for a
table, and this field is used in all the relations where this
table is used as a foreign table.
The definition of this relation is now done. Note that, although we did not relate
any of the fields in the
authors
table to another table, it can be done. For example,
we could have a country code in this table and could create a relation to the country
code of a country table.
We will discuss the benefits of having defined this relation in a later section, but first,
we will see what happens if our tables are in the InnoDB storage engine.
InnoDB Relations
The InnoDB storage engine offers us a foreign key system. To try it, we will first
switch our
topics
and
authors
tables to the InnoDB storage engine. We can do this
from the
Operations
sub-page in the Table view. We start by doing this for the
authors
table:
Search WWH ::
Custom Search