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.
Смотрите видео Database Constraints - What they are and How to use them онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Q Visible 23 Май 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 7,634 раз и оно понравилось 88 людям.