FOREIGN_KEY ConstraintsInnoDB supports foreign key constraints.
[CONSTRAINT symbol] FOREIGN KEY [id] (index_col_name, ...)[REFERENCES tbl_name (index_col_name, ...)[ON DELETE {RESTRICT | CASCADE | SET NULL | NO ACTION}][ON UPDATE {RESTRICT | CASCADE | SET NULL | NO ACTION}]
FOREIGN KEY constraint can reference a non UNIQUE key.
InnoDB checks UNIQUE and FOREIGN KEY constraints row-by-row.
How do I add InnoDB data files?
© 2007 John Michael Pierobon