Database Constraints - What they are and How to use them
Once you've gotten used to setting up tables and relating them together using primary and foreign keys you've reached a major milestone.
However if you share your database with colleagues or users without any safety measures, you're leaving your database open to problems. Especially when it comes to managing your data and keeping the integrity of your database intact!
In this tutorial we get into parent and child relationships - and how you don't want to leave any children in a database as orphans by deleting the parent record! We can prevent this form happening by putting rules or database constraints in place.
After I've gone through the theory I then move onto create a constraint in a sample database through phpMyAdmin. I also show the SQL statement needed if you're working with another relational database.
Watch video Database Constraints - What they are and How to use them online without registration, duration hours minute second in high quality. This video was added by user Q Visible 23 May 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,634 once and liked it 88 people.