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




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


26 responses to “phpMyAdmin tutorial: Setting up a foreign key constraint | lynda.com”

  1. 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. 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?

Leave a Reply