Primary Key & Foreign Key Implementation: MySQL

Показать описание

Implementation of Primary Key and Foreign Key, using MySQL
Practical approach and the benefits of using Primary and Foreign key concept in a relational database design.

Рекомендации по теме

Комментарии

In 24 minutes I understood what my colleagues at work were trying to teach me since last week! Thanks a lot!

alexx

I went through three other videos before this one finally made sense to me. Thank you so much!

jacobc

Thank you so much sir. After finding a lot this is the proper explanation of foreign key. Thanks to make this concept so easy.

aritora

Nice informative... Explanation with practical session helped me in recalling the forgotten things....

shrivatsavs

Very good video and very helpful, thank you for your contribution, I was helpful, easy and without many complications

AlterMetal

Thanks man. Simple and clear :)... Cheers !!!

BibeshManandhar

gracias no sabes como me ayudastes buen tutorial gracias de verdad

tatianamendez

hey satish, good example and explanation

RIMJANESSOHMALOOG

is there a way to use a row from one table as a column in another table, also as a foriegn key, so when a row is added to that table a column is added to the other table, thank you.

theafricanwalkchannel

Thank you very much for make this helpful video.

AAbir-pnwu

Hello Mr. Satish B
I would like to know can we make foreign key in mysql without executing a query as though we create table without firing the query i.e. manually???

vipinsaini

Appreciate your effort!!! I fee l that you could have been little slower... A beginner like me might face difficulty to follow the swift move...

dudelee

How do we auto fill data into foreign key that is linked to primary key of the other table?
So whenever any data is inserted into primary key, I want that to be filled into foreign key without me having to insert manually.
Any help would be appreciated.
Thanks

swetapatel

At 04:08 you say that we can have only one primary key in any given table. This is true, however, a primary key can consist of arbitrary many columns. I am not quite sure what your point is there.

IWasHereFirst

Can you please tell me why did you write auto_increment, next to INT?

StoicPhilosopher

Is it possible to view the CREATE statements after finish creating the table?

aslam

in the enrol Table, why did rol_no begin with a 3? (it is located at the 3:45 time mark). Its very own Auto Increment did not begin at 1.

shahshah

U r great brother. Keep it up. Kind request, don't use automatic align value in table. It makes little bit confusion while we learnt another concept like foreign key. Other than U r video is really so useful and excellent .... Thanks lot. 😘

baskaranbaluchamy

in the very beginning of your video, it clicked me about my mistake what I was doing in my databse... BTW thanku

Lifestyle

why do you keep primary key for enroll table rollid???

vinaysaivarma

Primary Key & Foreign Key Implementation: MySQL

Primary & Foreign Keys

Primary Key and Foreign Key Tutorial in MySQL | What is Primary Key and Foreign Key DBMS | Edureka

What is a Foreign Key Constraint? Understanding Primary & Foreign Keys

MySQL: FOREIGN KEYS are easy (kind of)

Primary Key Foreign Key Tutorial

Database Keys Made Easy - Primary, Foreign, Candidate, Surrogate, & Many More

Keys in RDBMS

36 ER Model: Constraints in ER Model|GATE|DBMS|Sudhakar Reddy Sir(AIR 200-GATE 24 DA) |MACSGATE

MySQL: PRIMARY KEYS are easy

11 - Constraints in SQL | Example | Primary Key | Foreign Key | NOT NULL | Unique | Check | Default

Working with Primary & Foreign key Constraint in SQL Server | SQL Server Tutorial

Difference between Primary Key and Foreign Key in SQL

CONSTRAINTS IN SQL || PRIMARY KEY || NOT NULL || DEFAULT || CHECK || UNIQUE || FOREIGN KEY || DBMS

Database Systems - Primary Keys and Foreign Keys

What is Primary key Foreign key | Oracle SQL Tutorial

Primary key vs Foreign key in data modelling Power BI | Power BI tutorial |

Concept of Keys in DBMS - Super, Primary, Candidate, Foreign Key, etc

TYPES OF KEYS IN DBMS || SUPER KEY || CANDIDATE KEY || PRIMARY KEY || FOREIGN KEY || ALTERNATE KEY

Primary Key, Foreign Key Concept, Practical Example in SQL

Foreign Key | SQL in Tamil | Logic First Tamil

Primary Key and Foreign Key in MySQL Explained with Examples | MySQL Tutorial

Lec-10: Foreign Key in DBMS | Full Concept with examples | DBMS in Hindi

Difference between Primary Key and Foreign Key in SQL (Example)

Первичный ключ, внешний ключ, суррогатный ключ / Илья Хохлов...