Hello and welcome to Part 2 of the article ‘Using Foreign Key constraints in MySQL. In this article we will look at what happens when we add, delete or update records in all the tables. So far we have three tables: employees, departments and projects. As you may recall from part 1 of this article, […]
Integrity
Using Foreign Key constraints in MySQL – Part 1
In this article we will look at how to use foreign key constraints in MySQL. We’ll be creating a Database with tables which are related to one another through the use of Foreign Keys. A Foreign key is nothing but a copy of a Primary Key in another table, think of it like a ‘link’ […]