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🖖

[@Prolly_JP]

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 💯

[@hitesh-patil]

Thank you for demonstrating in such an easy way.

[@Dclockvideos]

A true Godsend this is. Perfection. KZbin at its finest.

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

[@أسئلهومعلوماتثقافيه]

yes of course my love

[@DJFreshJuice]

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

[@MrWhinewine]

Thank you for taking your time explaining everything so clearly.

[@josezavala2309]

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

[@dr.girijanarasimhan3014]

good clarity tutorial, not unnecessary explanation

[@Sjwatts]

Filled in my knowledge gaps from college, cheers!

[@rashmikadeshan2710]

Thank you so much. Keep up the great work.

[@AkaiCindy]

i really appreciate the clear and accurate explanation

[@huemikai6]

Thank you so much! Straight forward and insightful

[@bsythdd4754]

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

[@bhanukaweerasekara525]

This is very helpful. Thank you very much. 👍

[@jamesr2408]

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

[@irminadaniel8711]

So straight to the point and very clear.

[@jonasmoyo9479]

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

[@vishalpattar5025]

Really delivered what expected from the video.

[@infoentertainia]

Bundle of Thanks. Very helpful video.

[@ninhongnguyen]

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

[@MeshaMesho]

thank you sir for that easy tutorial !!

[@maduabewardana7900]

Thank you,Its really important

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

[@sriramnagnath8302]

nice explanation in short period.

[@VicodeMedia]

I'm glad you liked it

[@SeisMan001]

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

[@drishtirajai7848]

Very helpful. Thumbs up to this guy!

[@udityadutta8929]

Best tutorial ever.... Thank you

[@danieltauil5457]

Great explanation! Thank you very much!

[@VicodeMedia]

You're welcome

[@harvirreturn]

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

[@maisonjoseph8281]

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

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

[@aclaputra8379]

Thank you sir great explanation

[@ashwanimodi25]

Thank you It was really helpfull. Thanks again

[@pheonixslayer21]

This was a life saver, thanks man!!

[@laudermarauder]

Thank you sir, this was perfect. Much appreciated.

[@snakewideo5474]

Thanks for this, this tutorial was very helpfull

[@laszlogyor6628]

Great job, thank you. 👍

[@steven361]

Straight to the point. Great video 👍

[@laibaabbasi3966]

helping material......thanks

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

[@prozio]

thanks for this short tutorial..

[@mosesegboh]

Lovely video, the best

[@ronnelmacompas1647]

Thanks man. This is really helpful

[@Zsolt055]

Thank you so much bro🤚

[@mahammad4051]

clear explanation, thank you !

[@jtrenchard1974]

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

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

[@creative.money_eu]

Awesome video.

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

[@ducminhduong7602]

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

[@alexa_ak6270]

very helpfull, thanks!

[@CarlMahnke]

Exactly what I needed!

[@presramh]

Well explained ! Thanks!

[@Gurpreetsdevlife]

Thanks bro, it helped

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

[@Nobody6364-x8p]

To the point. I liked it..

[@minwun]

thanks man this saved me

[@adnanmalik65901]

awesome vedio thanks

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

[@djaluyudhistira3835]

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

[@nandopookey9195]

thank you so much sir

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

[@juanmagm]

Gracias! Buena explicación.

[@cheemslovers8856]

Thank you soo much

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

[@thirilwin8309]

it is really helpful

[@cosminboglis5160]

Thanks! Very usefull!

[@Andrey007007PC]

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

[@arseneintwari6438]

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

[@danfrith924]

the last method seem way more fun! lol

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

[@LightningFox2407]

Super helpful - thanks!

[@nooruddin943]

Great....Thanks too...

[@zensks]

thank you so much!

[@kp7330]

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

[@johnnychunli]

straight to the point!

[@spencerntow3145]

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

[@shahindomar3958]

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

[@rahulshetty3849]

Thank you🙏

[@EliAzoura]

Thank you !

[@samisadat7451]

what to do when the datatyoes are not same?

[@VicodeMedia]

You IDs should always be integer

[@md.shorifulhasan3149]

Thanks a lot

[@kprakash9665]

hello how to use this all with html and css

[@buvaneshvaran8329]

Can you tell me how to update this data

[@alphaomondi484]

You can use SQL query to do so

[@soubhagyakumarbarik4374]

It doesn't allow deleting child row

[@imranlashari6578]

best

[@oleshka2588]

Thank you

[@guillermobautista4419]

1000 likes! Thanks!!

[@the_gost_gamer3841]

thanks

[@mirmuxsinkhamroev2552]

thanks man

[@francescomassaro546]

dope!

[@foreversingleeditz7207]

non skipable adds hnn

[@herdifariz7934]

thx man

[@kosminhokosmodosguri2038]

ty

[@whyjamesisacommonname]

wow!