1.7.2.3 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.8.6, “InnoDB and FOREIGN KEY Constraints”.