• Friday , 14 December 2018

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

Code Canyon



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

3d Ocean

Related Posts

26 Comments

  1. C Dorma
    October 1, 2018 at 12:09

    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

  2. Al M
    October 1, 2018 at 12:09

    Excellent explanation.

  3. Happy Sharma
    October 1, 2018 at 12:09

    Very helpful and easy to understand tutorial

  4. Funday Now
    October 1, 2018 at 12:09

    THanks My Son

  5. Albertus Sindhu
    October 1, 2018 at 12:09

    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?

  6. SEPAH CHANNEL
    October 1, 2018 at 12:09

    I dont have the 'index' when creating my table. Why?

  7. Johanna Julén
    October 1, 2018 at 12:09

    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!

  8. JMRC
    October 1, 2018 at 12:09

    Thanks

  9. Prasadini Lokuwel
    October 1, 2018 at 12:09

    Thank You sir….

  10. hfrmobile
    October 1, 2018 at 12:09

    Excellent tutorial!
    Exists there a way to change db type from MyISAM to InnoDB?
    Default was MyISAM in myPhpAdmin …

  11. Devesh Rawool
    October 1, 2018 at 12:09

    thank you very much mate

  12. Ali Hashmi
    October 1, 2018 at 12:09

    which version of wammp you are usinell me tg kindly

  13. Tai Ngo
    October 1, 2018 at 12:09

    thank you so much (y)

  14. Muile Asteg
    October 1, 2018 at 12:09

    Exactly what I needed, thank you so much!

  15. Sophie tsai
    October 1, 2018 at 12:09

    thank you very clear and understandable

  16. boniface lovegun
    October 1, 2018 at 12:09

    fabolus

  17. Leo Francis Lallana
    October 1, 2018 at 12:09

    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?

  18. Abdul Waheed
    October 1, 2018 at 12:09

    Thank You So Much You Saved my day

  19. Touhida Sultana
    October 1, 2018 at 12:09

    Thanks

  20. RelaxedKiller
    October 1, 2018 at 12:09

    I don't see the" "Choose column to display" option? Can someone help?

  21. ANKIT VAJANI
    October 1, 2018 at 12:09

    thank you sir, very helpful tutorial….

  22. Dannie Yo
    October 1, 2018 at 12:09

    thank u, very clear explanation sir.!

  23. SHOZAB HAIDER
    October 1, 2018 at 12:09

     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

  24. Dekhty Raho
    October 1, 2018 at 12:09

    Nice tutorial:-)

    – via YtPak(.com)

  25. T P
    October 1, 2018 at 12:09

    this is by far the best and most detailed explanation I've seen on foreign keys

  26. Jonathan Coleman
    October 1, 2018 at 12:09

    Great explanation

Leave A Comment

You must be logged in to post a comment.