Better database design with foreign keys and referential integrity in MySQL
Source: TechRepublic
Recent versions of MySQL have implemented support for foreign keys through the new InnoDB table engine. This document explains how it works.
Referential integrity refers to a state when all the references in a database are valid and no invalid links exist between the various tables that make up the system. The best way to achieve referential integrity is with foreign keys. Recent versions of MySQL have included support for foreign keys through the new InnoDB table engine. This download walks you through an example that shows you how to use this new MySQL feature in your database designs.
Foreign keys are relatively new in MySQL - has their inclusion simplified your database design process?Additional MySQL articles, downloads and discussions can be found using the MySQL tag.
This download is also available as a TechRepublic article.
Referential integrity refers to a state when all the references in a database are valid and no invalid links exist between the various tables that make up the system. The best way to achieve referential integrity is with foreign keys. Recent versions of MySQL have included support for foreign keys through the new InnoDB table engine. This download walks you through an example that shows you how to use this new MySQL feature in your database designs.
Foreign keys are relatively new in MySQL - has their inclusion simplified your database design process?Additional MySQL articles, downloads and discussions can be found using the MySQL tag.
This download is also available as a TechRepublic article.
| Format: | Size: | 52.00 | |
| Version: | 1.0 | Date: | Feb 2006 |
| Downloads: | 1609 |
