MySql 5 | Primary Key and Foreign Key in MySQL Explained with Examples

Primary Key and Foreign Key in MySQL Explained with Examples

[wedfarran]

thank you so much i was struggling on how to add a foreign key

[-tiktoktrend]

although I hardly understood the speech, but I got the concept, very good example, thank you

[anveshreddy]

I think u have to add dept id as foreign key in employee rather than employee id as foreign key in department as a department does not contain only one employee.

[Kennerdoll]

for easy understanding, you would have used different column names for PK and FK because we don't know from which table that EmpID is coming from.

[tanmaysinghal]

Didnt work for me... also in scheme not showing as foreign key

[youngdrae]

How do you alter tables to change primary key column, add foreign keys

[rock]

Speak properly, can't understand anything

[mariaahmed]

Speech isn't clear but got the concept!

[koenderbb]

"Country: London"
Is this the counterpart to "England is my city"?

[venkateshchowdary]

Speak properly, can't understand anything