Foreign Key in phpmyadmin

how to set up foreign keys in phpmyadmin. we are using two tables accounts and accounts_type. type id of accounts_type will be foreign in accounts table. i will show you how to do it in phpmyadmin.

Category:

Science & Technology

Tags:

• foreign
• key
• index
• phpmyadmin
• php
• primary
• set
• up
• setup
• configure
• connecting
• urdu
• configuring
• mysql

[demonslayermk235]

Thanks for the help.

[9081178]

@demonslayermk235 you're welcome :)

[guitarist809]

Thanks for this. I was getting frustrated before I watched this because I didn't realize I needed to create an index on the fields that were going to have a foreign key. I guess PMA lets you have an internal one which really doesn't accomplish the same thing unless you do all your work within PMA.

In response to everyone to can't hear this, turn up your damn volume.

[9081178]

@guitarist809 thanks buddy :)

[CareToSeeMyMimes]

cant bloody hear a thing

[9081178]

@CareToSeeMyMimes put on your headphones!

[9081178]

@sushiD100 well atleast i made an attempt to help others.

[BABURAOIU]

@spooofcouk i think this guy tried to show the direct way... i loved it, just what i wanted

[MrAbIRaZ]

thanks man..helped me a lot..

[FLMelodies]

Thanks, helped.

[9081178]

@rezzraz you're most welcome.. i'm glad i helped you out :)

[9081178]

@vd5vitor yuo're welcome.. :)

[vd5vitor]

thanks!

[rezzraz]

I just wanted to thank you, you showed the exact feature I was looking for.