How to create foreign key in phpMyAdmin

How to create foreign key in phpMyAdmin.
Learn Advanced MySQL Features in PHP.
Buy Me a Coffee ;)
paypal.me/Vict...
Hosting I Use:
m.do.co/c/e924... (Get $100 in credit over 60 days)

[@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

[@bharathgohrani1043]

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

[@Dev_Jet]

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

[@hitesh-patil]

Thank you for demonstrating in such an easy way.

[@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

[@DJFreshJuice]

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

[@Dclockvideos]

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

[@josezavala2309]

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

[@MrWhinewine]

Thank you for taking your time explaining everything so clearly.

[@irminadaniel8711]

So straight to the point and very clear.

[@akaijoe3582]

i really appreciate the clear and accurate explanation

[@nomnomfuckthisnewnick]

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

[@Sjwatts]

Filled in my knowledge gaps from college, cheers!

[@jonasmoyo9479]

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

[@pheonixslayer21]

This was a life saver, thanks man!!

[@jamesr2408]

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

[@vishalpattar5025]

Really delivered what expected from the video.

[@rashmikadeshan2710]

Thank you so much. Keep up the great work.

[@SeisMan001]

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

[@laibaabbasi3966]

helping material......thanks

[@bhanukaweerasekara525]

This is very helpful. Thank you very much. 👍

[@maduabewardana7900]

Thank you,Its really important

[@drishtirajai7848]

Very helpful. Thumbs up to this guy!

[@danieltauil5457]

Great explanation! Thank you very much!

[@VicodeMedia]

You're welcome

[@MeshaMesho]

thank you sir for that easy tutorial !!

[@bsythdd4754]

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

[@ninhongnguyen]

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

[@udityadutta8929]

Best tutorial ever.... Thank you

[@infoentertainia]

Bundle of Thanks. Very helpful video.

[@steven361]

Straight to the point. Great video 👍

[@aclaputra8379]

Thank you sir great explanation

[@harvirreturn]

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

[@CarlMahnke]

Exactly what I needed!

[@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

[@sriramnagnath8302]

nice explanation in short period.

[@VicodeMedia]

I'm glad you liked it

[@laszlogyor6628]

Great job, thank you. 👍

[@laudermarauder]

Thank you sir, this was perfect. Much appreciated.

[@ashwanimodi25]

Thank you
It was really helpfull.
Thanks again

[@maisonjoseph8281]

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

[@cheemslovers8856]

Thank you soo much

[@snakewideo5474]

Thanks for this, this tutorial was very helpfull

[@prozio]

thanks for this short tutorial..

[@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.

[@minwun]

thanks man this saved me

[@johnnychunli]

straight to the point!

[@mahammad4051]

clear explanation, thank you !

[@ronnelmacompas1647]

Thanks man. This is really helpful

[@jtrenchard1974]

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

[@Zsolt055]

Thank you so much bro🤚

[@chakibbounoun2349]

To the point. I liked it..

[@nooruddin943]

Great....Thanks too...

[@alexa_ak6270]

very helpfull, thanks!

[@presramh]

Well explained ! Thanks!

[@mosesegboh]

Lovely video, the best

[@nandopookey9195]

thank you so much sir

[@daltonrandall4348]

When you make the foreign key and then hover over each ID that is linked, how does the database know which column to show you (in this case, you only have a "name" column, but say there were a dozen columns in the "users" table)? Thanks!

[@donpornrodkrajub5234]

thank you

[@EliAzoura]

Thank you !

[@dailydoseofluv]

thank you so much!

[@LightningFox2407]

Super helpful - thanks!

[@cosminboglis5160]

Thanks! Very usefull!

[@juanmagm]

Gracias! Buena explicación.

[@devthings01]

Thanks bro, it helped

[@imranlashari6578]

best

[@adnanmalik65901]

awesome vedio thanks

[@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?

[@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

[@danfrith924]

the last method seem way more fun! lol

[@thirilwin8309]

it is really helpful

[@md.shorifulhasan3149]

Thanks a lot

[@the_gost_gamer3841]

thanks

[@ducminhduong7602]

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

[@rahulshetty3849]

Thank you🙏

[@whyjamesisacommonname]

wow!

[@Andrey007007PC]

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

[@djaluyudhistira3835]

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

[@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;

[@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;

[@francescomassaro546]

dope!

[@herdifariz7934]

thx man

[@mirmuxsinkhamroev2552]

thanks man

[@arseneintwari6438]

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

[@kosminhokosmodosguri2038]

ty

[@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

[@paungster]

👍

[@shahindomar3958]

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

[@definitelynotje]

ey thanks

[@kp7330]

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

[@spencerntow3145]

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

[@guillermobautista4419]

1000 likes! Thanks!!

[@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

[@soubhagyakumarbarik4374]

It doesn't allow deleting child row

[@kprakash9665]

hello how to use this all with html and css

[@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.

[@foreversingleeditz7207]

non skipable adds hnn

[@samisadat7451]

what to do when the datatyoes are not same?

[@VicodeMedia]

You IDs should always be integer