Databases Reference
In-Depth Information
phpMyAdmin offers to define only one display column for a
table, and this column is used in all the relations where this table
is used as a foreign table.
The definition of this relation is now done. Although we did not relate any of the
columns in the
author
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.
For now, we will see what happens if our tables are under the control of the
InnoDB
or
PBXT
storage engine.
Foreign key relations
The
InnoDB
and
PBXT
storage engines offer us a native foreign key system.
At your choice, the exercises in this section can be
accomplished with either
InnoDB
or
PBXT
storage engines.
InnoDB
has been chosen in the text.
For this exercise, our
book
and
author
tables must be under the
InnoDB
storage
engine. We can do this from the
Operations
page in the
Table
view.
Search WWH ::
Custom Search