Jump to content

Archived

This topic is now archived and is closed to further replies.

angelali

How to create foreign key in PHPMyAdmin?

Recommended Posts

I am having a big problem creating foreign key on PHPMyAdmin. I saw many people having this problem... Never I did this before, so I tried but could not figure out... In Microsoft Access, you do it directly, but on PHPMyAdmin, its a bit complicated..

 

I have two tables, as follows:

 

User

-user_id (Primary key)

-name

-age

-country

 

Job

-job_id (Primary key)

-job_name

-job_place

 

What I want is to make user_id as foreign key in Job table.

 

Can you explain me how to do it with the GUI PHPMyAdmin instead of query?

Share this post


Link to post
Share on other sites

Click a table, then click Structure, then click Relation View.

Share this post


Link to post
Share on other sites

And you are the idiot who posted in a topic that hasn't had a reply in over 6 months. We all have our defects, right?

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.