dancingbush
dancingbush

Reputation: 2281

How to define a foreign key using phpMyAdmin GUI in mySQL

I am creating a table using the GUI in phpMyAdmin mySQL hosted on an Apache web server (XAMMP).

How do I define a column as a foreign key and where do I insert the reference to the corresponding primary key? There is a drop down option for Primary Key but I don't see any such option for a foreign key.

The options for each column are as below Thanks

Upvotes: 0

Views: 617

Answers (1)

nbk
nbk

Reputation: 49400

Find the Relation view see picture and there you can define our foreign keys.

relation view

Upvotes: 2

Related Questions