1.8.2.4 Foreign Key Differences

MySQL's implementation of foreign keys differs from the SQL standard in the following key respects:

For information about how the InnoDB storage engine handles foreign keys, see Section 14.6.5.6, “InnoDB and FOREIGN KEY Constraints”.