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 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/
Xem thêm Bài Viết:
- TRÒ CHƠI "XOẮN NÃO" DỄ QUẠO NHẤT VỤ TRỤ | Nabee TV
- Conversation with foreigners in English | Learn English for all levels
- Cố Chấp – Về Nơi Đâu (Phần 1) – TraCy Thảo My [ Official Music Video ]
- Học trực tuyến trên truyền hình MyTV: Giải pháp tối ưu mùa Covid-19
- Hướng dẫn sử dụng tính năng Điều khiển tivi (Remote Controller) trên MyTV và MyTV Net
Thank you!
Thank you so much! The Relation View is up the structure
wow !
super phpmyadmin
i am like it
wow !
Code works great…
Thank you
This video is very helpful.
Very good explanation! Nice one. Now I can make Foreign Key easily.
I don't get a relation view
2:46 …. I don't have the option FOREIGN KEY CONSTRAINED, how to add the FK then?
Well, this is why Lynda. Thank you sir
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.
great video.. love the accent.. most importantly.. got the job done…
CLEAR and CONCISE!
GREAT Explanation!
tangina pano yung choose column to display . tangina mo kasi outdated to
@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
Outdated. Relations page looks nothing like this
Thanks man….it helped me lot
i dont have the option relation
thanks man you
Thanks sir…
Thanks a lot! it was so very useful
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.
THanks My Son