MySQL 16 - Foreign Key

[@melvar1309]

Thanks, these videos are short and to the point which helps a lot when I just want to check out some specific concepts for a project that I'm working on and I have to use MySQL

[@hyperhippyhippohopper]

4:36 Somebody has got to get Batman a foreign key for his birthday

[@justinrocky6645]

ua-cam.com/video/rRmI16IkqG0/v-deo.html

[@unknownad_official]

thank you!
that was exactly what i were looking for

[@sergeyvikulov2622]

Caleb, could you explain is it possible or acceptable to create a foreign key to a field in another table and this field is a foreign key which references to a primary key in another table yet? For example a table `cities` has a field called `cities`.`region_id` which is foreign key to table `regions` (field `regions`.`id`) and a table `stations` has a field `stations`.`region_id` which is foreign key to table `cities` and references to `cities`.`region_id` but not `regions.id`?
Thank you for your videos! They are very useful!

[@justinrocky6645]

ua-cam.com/video/rRmI16IkqG0/v-deo.html

[@Romeo-vt8hq]

Bro your videos are the best, you have a talent at explaining thing. Thanks you =)

[@VandalStreet]

Helpful lecture. Good job!

[@justinrocky6645]

ua-cam.com/video/rRmI16IkqG0/v-deo.html

[@rakhshandamujib2793]

Can you tell me how to filter data in both parent and child tables using the primary key?

[@justinrocky6645]

ua-cam.com/video/rRmI16IkqG0/v-deo.html

[@etinosaizekor6533]

Great video, Caleb!

[@stackoverflow2522]

happy new year

[@BharatSingh-zk8lx]

it's little confusing at 3:00 and 4:30. At 3:00 u made two references and at 4;30 u said only one ref. can be made, please explain

[@KarimaKadaoui]

The 'Unique' constraint is optional. If you set it, then a parent can't have more than one child. Otherwise, it's possible.

[@justinrocky6645]

@@KarimaKadaoui ua-cam.com/video/rRmI16IkqG0/v-deo.html

[@justinrocky6645]

ua-cam.com/video/rRmI16IkqG0/v-deo.html

[@csharp8703]

That first example was not very good but the rest worked fine

[@justinrocky6645]

ua-cam.com/video/rRmI16IkqG0/v-deo.html

[@windyboy1995]

Thank you a lots (Y).

[@justinrocky6645]

ua-cam.com/video/rRmI16IkqG0/v-deo.html

[@marcelijankowski9593]

Golden

[@zgwenwen]

why do you have two children with ID 7 reference to same parent? (3:00)

[@gioac96]

One clear example of this could be a comments table that stores comments submitted by users in a social network. Each user can comment more than once on a single post, but every comment must always reference its author

[@EricCartmanFTW]

great example. thx mate

[@justinrocky6645]

ua-cam.com/video/rRmI16IkqG0/v-deo.html

[@justinrocky6645]

@@gioac96 ua-cam.com/video/rRmI16IkqG0/v-deo.html

[@justinrocky6645]

@@EricCartmanFTW ua-cam.com/video/rRmI16IkqG0/v-deo.html

[@chrisjob356]

watching this in 2017.

[@justinrocky6645]

ua-cam.com/video/rRmI16IkqG0/v-deo.html

[@osamaabdelqader438]

you are awesome

[@justinrocky6645]

ua-cam.com/video/rRmI16IkqG0/v-deo.html

[@GAURAV-xd1pi]

fk