Databases Reference
In-Depth Information
Let's click at the appropriate place to delete this relation. We get a confirmation panel
on which we click
Delete
:
We can then proceed to recreate it. For this, we start by clicking the
Create relation
icon. The cursor then takes the form of a short message saying
Select referenced key
.
In our case, the referenced key is the
id
column of the
author
table; thus we bring
the cursor on this column and click. A validation is done, ensuring that we chose a
primary or unique key.
Next, the cursor having changed to
Select foreign key
, we bring it to the
author_id
column of the
book
table and click again. We then confirm the relation creation.
Currently, the interface does not permit to create compound keys (having more than
one column).
InnoDB Relations
To delete or define a relation between InnoDB tables, the procedure is the same as for
internal relations, except that at creation time, a different confirmation panel appears,
enabling us to specify
ON DELETE
and
ON UPDATE
actions.
Search WWH ::
Custom Search