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.
Watch video Create a foreign key in phpmyadmin and relate to primary key online without registration, duration hours minute second in high quality. This video was added by user Q Visible 02 February 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 187,116 once and liked it 1.1 thousand people.