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 …
Original source
phpMyAdmin tutorial: Setting up a foreign key constraint | lynda.com
26 responses to “phpMyAdmin tutorial: Setting up a foreign key constraint | lynda.com”
Maybe be helpful to explain why you chose "Restrict" rather than just glide over it. If I want to delete a value then how is that going to work with getting a sql error every 2 seconds
Excellent explanation.
Very helpful and easy to understand tutorial
THanks My Son
how to make store procedure using join table? there is an error in mysql says set foreign key = on, and i dont know why, can you explain that sir?
I dont have the 'index' when creating my table. Why?
Nice! Looks a bit different in my version, but this very well explains what's what and I have now created my first foreign key myself. Yay!
Thanks
Thank You sir….
Excellent tutorial!
Exists there a way to change db type from MyISAM to InnoDB?
Default was MyISAM in myPhpAdmin …
thank you very much mate
which version of wammp you are usinell me tg kindly
thank you so much (y)
Exactly what I needed, thank you so much!
thank you very clear and understandable
fabolus
But what if you have two columns on makes table? For example: `make_id` (PK), `make`, and another called `country` (assuming you need to know which country these manufacturers come from). If I hover my mouse to the `cars` -> `make_id`, would it display Toyota, Japan?
Thank You So Much You Saved my day
Thanks
I don't see the" "Choose column to display" option? Can someone help?
thank you sir, very helpful tutorial….
thank u, very clear explanation sir.!
mysql said #1452 can' add or update a child row
please help
i want add department_id p.k in table dept. As f.k in table employee
Nice tutorial:-)
– via YtPak(.com)
this is by far the best and most detailed explanation I've seen on foreign keys
Great explanation