Create a foreign key in phpmyadmin and relate to primary key

Create a foreign key in phpmyadmin and relate to primary key



Primary keys and foreign keys and how they relate together is the crux of how relational databases work. in this video I add a foreign key to the students table named course_fk. I index field and then through the relation view I relate this field to the primary key field course_id in the courses table.
Through the video I highlight how relationships work and how the constraints that are part of relationships in a relational database force the integrity of data by ensuring values in the foreign key must relate to valid IDs in the primary key it is related to.

source

phpmyadmin and Queries

phpmyadmin and Queries



This web programming courses is intended to be the one stop solution for web development training.
We bring together the bunch of most popular web technologies and present them in a way which ensures quick and through learning.

To Buy Laravel 5 at 50% discount click here-

■ Thank You!!! A Comment would be appreciated 🙂
Also, Don’t forget to hit the “Like” button, and make sure to subscribe to the Eduonix Learning Solution Channel for more videos

➢ Follow us on other social networks :
■ Facebook :
■ Linkedin :
■ Instagram : | @eduonix

source

phpMyAdmin tutorial: Setting up a foreign key constraint | lynda.com

phpMyAdmin tutorial: Setting up a foreign key constraint | lynda.com



In a relational database such as MySQL, foreign keys are used to link records in different tables. Additionally, you can set up foreign key constraints to control what happens when records are inserted, updated, or deleted. Find out how to build foreign key constraints in this tutorial. Watch more at

This tutorial is a single movie from the Up and Running with phpMyAdmin course by lynda.com author David Powers. The complete course is 2 hours and 33 minutes and shows how to administer MySQL databases, design tables, and insert, update, and delete data with phpMyAdmin.

Introduction
1. Why Use phpMyAdmin?
2. Setting Up phpMyAdmin Locally
3. Creating Tables
4. Importing and Exporting Data
5. Dealing with Foreign Keys
6. Running Queries
7. Checking Performance
Conclusion

source