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.

[hackerprime]

Much love from Jamaica. It's amazing how this video is 4+ years old and it helped perfectly.

[touka]

Thanks for saving my project! very clear tutorial and great voice too 🔥

[xoxoo]

If you have error #1452 go-to 4:08.
Wonderful explanation of why this error occurs. Thank you, I just realized where was my problem whole this time spent on google looking for the solution to my problem.

[aldangelo]

Nice and clear. Ah, so rare. Thanks so much!

[BriO]

Thanks ob wex! Great job, well explained. Was hung up with the generic error & at 4' video mark you solved my problem. I hadn't setup the foreign key default value correctly, so now I see obvious matching problems with the reference key. I corrected by setting a default value. TU

[THEJOENATOR]

this video just saved my job and life.

[GohersWay]

So what Restrict and Cascade mean : First thing to know is, Google Definition : The table containing the foreign key is called the child table, and the table containing the candidate key is called the referenced or parent table.
Here Foreign key is set as child of a Parent table,
Restrict on delete : it mean that you are restricted to delete a row in parent row ( record ) that is a reference of a foreign key.
Cascade on update: if a parent record ( reference column ) is updated, cascade will auto update the child row as well.

[LightningFox]

Didn't know you had to index! Thanks! :)

[FlightSimMuseum]

Very very helpful video!!!
Setting the database type to innoDB first may be worth a mention too.

[tanny_edits]

Really need this to my transaction system

[doublet]

thank you so much. god bless you bro. it helped me so much . thanks

[alisona]

Thank you very much, your videos have been very helpful to me!

[dembasissoko]

Great video! I was able to understand the foreign key constraint setting better. However, your mention of one to many relationship between the course and student tables is not correct. It is actually a many to many relationship: each student can register for many courses and each course have can many students. That's why you'd need an intersection table (i.e. enrollment) to eliminate that many to many relationship. Thanks for the video.

[abdullahal-sakif]

It's a great help, sir. Jazakallahu khair :)

[vaticinus]

So if the student has multiple courses you have to make a table for each course??

[hackerprime]

Is it possible to insert into a table with a foreign key without inserting anything into the table with primary key/child table?

[rw]

i dont have the index as a drop down or relation view? is my php old version or yours?

[sss-ksyk]

good! there is any video that explain many to many relationship?

[ramaken]

thank you, i appreciate a lot. Subscribed

[Jonathan-mkju]

great little video. Do you have one in your list to display the related data via PHP