How to create foreign key in phpMyAdmin

[@ImranIsak]

Top tip, if you *don't see the relations view tab*
1) Select your table
2) Click operations in the navigation, at the top
3) Change the engine to InnoDB

[@tertiusscheepers8357]

Thanks buddy i could not see the table in the tables field. This tip sorted me out👍

[@antoniofuller2331]

Hmm

[@Ronhtokk108]

Thanks!!

[@Ch0cken]

Legend

[@juanmagm]

Thanx🖖

[@pascallasalo1445]

You are a blessing from God, may he protect and give you success in life. I pray you have long life, filled with joy and happiness.

[@nick_jacob]

I struggled with this for two whole days reading documentation. I understand it but for some reason nothing was working. I scrapped my database and recreated it. I had no idea the designer view was available and that was super awesome to see. Thumbs up for this.

[@rizkancool]

Great Tutorial , without wasting the time explaining the methods in very clear way

[@Dev_Jet]

I really appreciate the clear and accurate explanation. This was a fantastic tutorial!

[@bharathgohrani1043]

Brother it is amazing people like you, who keep this world moving forward. Respect 💯

[@DJFreshJuice]

Really helpful! The documentation for this was so bad and this really helped me out, thank you!

[@josezavala2309]

Thank you for getting to the point and explaining this topic clearly!

[@hitesh-patil]

Thank you for demonstrating in such an easy way.

[@irminadaniel8711]

So straight to the point and very clear.

[@MrWhinewine]

Thank you for taking your time explaining everything so clearly.

[@Dclockvideos]

A true Godsend this is. Perfection. UA-cam at its finest.

[@pheonixslayer21]

This was a life saver, thanks man!!

[@jonasmoyo9479]

Thank you very much this was easy and straight to the point.

[@steven361]

Straight to the point. Great video 👍

[@akaijoe3582]

i really appreciate the clear and accurate explanation

[@Sjwatts]

Filled in my knowledge gaps from college, cheers!

[@laudermarauder]

Thank you sir, this was perfect. Much appreciated.

[@gedankens4029]

Great, simply but effective explained. But also important: id columns have to be same data type and same attribute, else it will not work.

[@user-uz3pb1xo1w]

yes of course my love

[@drishtirajai7848]

Very helpful. Thumbs up to this guy!

[@vishalpattar5025]

Really delivered what expected from the video.

[@jamesr2408]

Very useful. Patched the holes in my head. Thanks. ;-)

[@nomnomfuckthisnewnick]

Thanks for the tutorial, this help me so much on my final exam

[@CarlMahnke]

Exactly what I needed!

[@maisonjoseph8281]

Thanks a million, Sir...
That was so helpful

[@johnnychunli]

straight to the point!

[@snakewideo5474]

Thanks for this, this tutorial was very helpfull

[@infoentertainia]

Bundle of Thanks. Very helpful video.

[@bsythdd4754]

nice! now i know how to create foreign key in myphpadmin. thanks!

[@udityadutta8929]

Best tutorial ever.... Thank you

[@SeisMan001]

Finally i forgot to change my foregin key to unsigned that worked!

[@rashmikadeshan2710]

Thank you so much. Keep up the great work.

[@jtrenchard1974]

Thanks - really 'to-the-point' - helpful!

[@ashwanimodi25]

Thank you
It was really helpfull.
Thanks again

[@ronnelmacompas1647]

Thanks man. This is really helpful

[@LightningFox2407]

Super helpful - thanks!

[@danieltauil5457]

Great explanation! Thank you very much!

[@VicodeMedia]

You're welcome

[@bhanukaweerasekara525]

This is very helpful. Thank you very much. 👍

[@mahammad4051]

clear explanation, thank you !

[@MeshaMesho]

thank you sir for that easy tutorial !!

[@maduabewardana7900]

Thank you,Its really important

[@aclaputra8379]

Thank you sir great explanation

[@prozio]

thanks for this short tutorial..

[@presramh]

Well explained ! Thanks!

[@juanmagm]

Gracias! Buena explicación.

[@djaluyudhistira3835]

I still don't understand. I can't gives two Foreign Key Constraints for One Constraint properties. Why ?

[@laszlogyor6628]

Great job, thank you. 👍

[@ninhongnguyen]

Wow, just a short video but it's very useful

[@sheetalchand8546]

Question: can we not create a foreign key without index first? If we have to create a foreign key in a query do we first need to set index and then creat fk?

[@gurpreetkait]

Thanks bro, it helped

[@minwun]

thanks man this saved me

[@kp7330]

Sir how can you store user table id in posts table i want know that pls sir.

[@ducminhduong7602]

I don't understand, do I need to create two CRUDs for two tables so it can connect to each other?

[@harvirreturn]

Top tip, if it fails, then check if the attribute and type are the same eg. int(10), unsigned

[@laibaabbasi3966]

helping material......thanks

[@chakibbounoun2349]

To the point. I liked it..

[@shahindomar3958]

Sir,
Can You tell Me.How I can Insert data into database using Php Form.

[@alexa_ak6270]

very helpfull, thanks!

[@Andrey007007PC]

great! but why we need update attribute if we used only delete example

[@mosesegboh]

Lovely video, the best

[@cireguisse7499]

how did you create the user_id before making it a foreign key in posts table ? how the post is automatically assigned to the author id ? thanks

[@xaviorxason2611]

Yes, I'm wondering the same thing. if u found answer pls let me

[@creative.money_eu]

Awesome video.

[@dailydoseofluv]

thank you so much!

[@EliAzoura]

Thank you !

[@Zsolt055]

Thank you so much bro🤚

[@JohnSmith-xt8xu]

In our bachelors in hons (BSIT) we did ever did not create a foreign key and after 4 years the video learn me how to make foreign key, universities now a days are producing waste, nive and aimless generation no counselling no future careers just complete semesters and credit hours fuck that

[@nooruddin943]

Great....Thanks too...

[@cosminboglis5160]

Thanks! Very usefull!

[@cheemslovers8856]

Thank you soo much

[@nandopookey9195]

thank you so much sir

[@thirilwin8309]

it is really helpful

[@adnanmalik65901]

awesome vedio thanks

[@arseneintwari6438]

what do i do if i have more than one foreign key which foreign keu do i choose??

[@donpornrodkrajub5234]

thank you

[@md.shorifulhasan3149]

Thanks a lot

[@spencerntow3145]

i need help bro my brand ID and category ID always zero

[@rahulshetty3849]

Thank you🙏

[@francescomassaro546]

dope!

[@danfrith924]

the last method seem way more fun! lol

[@sriramnagnath8302]

nice explanation in short period.

[@VicodeMedia]

I'm glad you liked it

[@AntonioSouzaISC]

Thanks

[@rw7799]

i dont see a relation view button in my new table but have one in my users table... not sure why

[@Josh-Casey]

Change storage engine to InnoDB. Under Operations tab in PHPMyAdmin, or run ALTER TABLE your_table_name ENGINE=InnoDB;

[@herdifariz7934]

thx man

[@oleshka2588]

Thank you

[@whyjamesisacommonname]

wow!

[@imranlashari6578]

best

[@kosminhokosmodosguri2038]

ty

[@kprakash9665]

hello how to use this all with html and css

[@the_gost_gamer3841]

thanks

[@sosscs]

I cannot find the relation view, and for some reason, I cannot also fine the left panel tree

[@Josh-Casey]

Change storage engine to InnoDB. Under Operations tab in PHPMyAdmin, or run ALTER TABLE your_table_name ENGINE=InnoDB;

[@ciscocapita]

Thanks but i can´t see the funtion relation view in new version, can u helpe me?

[@BharathYammanur]

Change table's database engine to innodb

[@mirmuxsinkhamroev2552]

thanks man

[@paungster]

👍

[@foreversingleeditz7207]

non skipable adds hnn

[@soubhagyakumarbarik4374]

It doesn't allow deleting child row

[@adamakomou7318]

Would be better if you could slow down when actually creating the Foreign Key Constraint. I didn't understand the Constraint Properties input "Test".

[@alphaomondi484]

I think test is just a name given to the foreign key

[@dhavalsanghvi2283]

once i created foreign key than i am not able to insert data in database can you help me out

[@alphaomondi484]

You should insert data in the users table first

[@IshiroaKimita]

how did you code this to update the user_id when the post were submitted??

[@VicodeMedia]

What do you mean?

[@IshiroaKimita]

@@VicodeMedia
No matter the constraints I use, when I try to update the foreign key in the table it gives an error saying I can't update the foreign key.

[@guillermobautista4419]

1000 likes! Thanks!!

[@samisadat7451]

what to do when the datatyoes are not same?

[@VicodeMedia]

You IDs should always be integer