phpmyadmin- need help in foreign key creation

@patilashu01-wqV4iY • Oct 22, 2024

Oct 22, 2024

1.2K

hi..every1. i need a help in creating foreign keys in phpmyadmin. here.. i have used phpmyadmin for creating database. in this i have created 2 tables- employee and department. employee table has deptno as 1 of its attributes. this deptno is in department table as primary key..i have to define deptno of employee table as foreign key that references to deptno in department table. now, there is an option in phpmyadmin for including primary key constraints but there is no such option for includinf foreign key constraint..
plzzzz help...😔

Like 0 Replies 2

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

Manish Goyal

@manish-r2Hoep • Sep 26, 2010

There is a option buddy
First click on child table ,(I am assuming department is a child table here and employee is a parent table here)
Now click on structure
Now You will see options like Print view ,relation view at bottom
Click on relation view

Rest I hope you can do

PS😛lease if in future you have any query ,better create a new thread for this ,instead of asking through private messages, so that others can also take benefits .
Ok 😀
0
patil.ashu01

@patilashu01-wqV4iY • Sep 28, 2010

hey...thanx buddy....thanx a lot.. i gt it!!! thanx:smile:
0