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
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.
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 under control of the InnoDB
storage engine.
InnoDB Relations
The InnoDB storage engine offers us a foreign key system. To try it, we will first
switch our
topic
and
author
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
author
table:
A problem might arise when changing the storage engine of
book
table to InnoDB.
We have a full-text index in this table, and some versions of MySQL do not support
it for the InnoDB engine. We have to remove the full-text index if we receive the
following error message.
Search WWH ::
Custom Search