Reputation: 2281
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.
Upvotes: 0
Views: 617
Reputation: 49400
Find the Relation view see picture and there you can define our foreign keys.
Upvotes: 2