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

27
2



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 what happens when records are inserted, updated, or deleted. Find out how to build foreign key constraints in this tutorial. Watch more at

This tutorial is a single movie from the Up and Running with phpMyAdmin course by lynda.com author David Powers. The complete course is 2 hours and 33 minutes and shows how to administer MySQL databases, design tables, and insert, update, and delete data with phpMyAdmin.

Introduction
1. Why Use phpMyAdmin?
2. Setting Up phpMyAdmin Locally
3. Creating Tables
4. Importing and Exporting Data
5. Dealing with Foreign Keys
6. Running Queries
7. Checking Performance
Conclusion

Nguồn: https://saesrpg.net/

Xem thêm bài viết khác: https://saesrpg.net/giai-tri/

27 comments

  1. Víctor López 12 July, 2020 at 19:54 Reply

    To make this tutotial a little bit more understandale, you could have picked better names for you tables. "Makes" could have "manufacturer"
    , and cars could have been "car_model". The problem with confusing names is that if you are not the only person in a proyect, or if someone else is going to continue it, that "someone else" will have a difficult time trying to put the dots together.

  2. Chris Banana 12 July, 2020 at 19:54 Reply

    @4:45
    Found this problem so started to watch videos on youtube. But your solution is not on my screen. I looked all over for a "choose column to display" type setting, and nothing 🙁

    edit:
    I was using a website to manage myphpadmin. I installed it locally and used the newest version and the option is there

  3. C D 12 July, 2020 at 19:54 Reply

    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

Leave a reply