Complete Web Developer Chapter 4 - Lesson 13 Foreign Key Constraints

In this video we learn how to use Foreign Key constraints to help protect related data. We looked at two common options for setting up the foreign key constraint. We looked at restrict, which will stop you from deleting rows where there is related data associated with it. We also looked at cascade which will prevent orphaned rows in related tables by cascading the delete down to those relations.

This is part of a complete series to learn web development from absolute beginner to job-ready.

In this series, we are going to learn the following technologies.

HTML
CSS
Javascript
PHP
OOP PHP
MYSQL
Git
MVC
Node.js
React.js