phpMyAdmin MySQL database - How to create table, insert data, set up foreign key

In this tutorial you will learn how to create a table in phpMyAdmin for a MySQL database, and how to insert data into the table, followed by how to set up a foreign key, so that the values of one column in the one table refer to values of a column in another table.

[@Purple-Astro]

Thank you bro you saved me a lot of time .Best video I 've seen so far.

[@smithvance4162]

thanks.. your explanations are lot more easier to understand

[@mbh9849]

i love you!!! thank you so so so so so so much! i have an exam in a couple of days and this really helped me out since wamp DID NOT want to load and neither did any similar app this has been helpfull thank you!:

[@sinoiumarzoda4257]

You are saving lives man. Thanks a lot.

[@iherdu2]

Incredibly helpful in creating my dog database. Thanks!

[@basit8507]

thank you man, its really helpful

[@aboltube4067]

Thank you . God blessed you !!!

[@rohitsingh1039]

thanku how are u

[@omaralomari3774]

Thank you very much mate ,I was havig trouble with a course ,and this hepled me a lot .

[@gitanjalikumari9262]

Thanks for nice explanation 👍

[@noranida8647]

This helped a lot

[@indwr]

i can understand easily your tutorial thanku for sharing your knowledge

[@faroukthenoob-ftn9610]

Thank you mate

[@WaqarAli-me5xg]

Its helpful for me.thank you

[@YO-in2ij]

blessings upon you and your entire family

[@nurerinna11]

I should create the database of magikemw first? Then how to create the magikemw_test??

[@pockeybearmilk264]

Thank you very much , you helped me a lot

[@anthonyghossein9035]

amazing tutorial man , keep it upppp

[@natalyastaehr]

Thank you for sharing

[@nasmeir]

good video:). I want to ask, can we import excel file with multiple sheet into mySQL?

[@vishnuvundamati5228]

Muchas Gracias!!!

[@shazibroy8090]

Thank a lot. Extremely helpful. Do you have any more videos regarding phpmyadmin?

[@savenamanimaran3346]

Thank you for the tutorial!

[@MrMarclauren]

Awesome tut!!!!

[@g.pavani5275]

Thank you 👍🏽

[@zaidpathan339]

Thank you hearty for your tutorial.

[@mark-cr4by]

thanks man.

[@patriciandawah5262]

this site help me with my assignment

[@Smanack345]

Really helpful! thanks.

[@hauntingmachine]

you saved me

[@yoyo5022]

Thumb up for the "Taipei, Taiwan", the dummy address

[@nkiangmatiahjunior6451]

Thanks greatly appreciated

[@souravsen5773]

Doesn't a table only can have 1 primary key?

[@m3assetsllc439]

He's illustrating the 'concatenated' or composite key concept which becomes an FK.

[@JaveLester]

@@m3assetsllc439 F*ck Key

[@animecon15]

Omg thank you

[@rohitsingh1039]

welcome

[@divyanisarda1018]

Could u pls help me
Like i have created a table of journal Details and inside it i have emp_id journal name article title year volume issues.
But i have to add inside this indexing which i have added under indexing i have to add Sci, Sci-E, and others under indexing so how do i add could u pls help me

[@ShowShineAU]

Can"t believe that this guy knows Taibei

[@somgaur3037]

how you created
magikemw
magikemw_test
magikemv_video

[@vannak168pov5]

Thank you so much admin can you post a new Video contact DBMS

[@mohammadakbarhashimi6759]

how to create sub databse to import their related tables to that databse

[@abdulazizmusa4816]

which version are you using please

[@ocampojeviejana.8899]

nice

[@ankitashrivastava9698]

sir in my php relation view not shown than what i can do

[@chiranjeevichowdary5948]

how to sort table user doesnt exist errror?

[@technoseek]

Thanks for this

[@SMohammedAfruddin]

Hi why the password was not showing correctly in database table? Please help me

[@nambao966]

Hi i left the value blank but it does not set default as " Null"? in this video ,you can do it?

[@maroofkhatib3421]

thanks man

[@MaryNyilma]

How can I download

[@paulsoaresjr12345678]

okay HOW DO YOU DELETE DATA?????

[@nanakwaku6536]

Is there anyway I can personally contact you? I really want to learn coding in phone. I'm in Ghana and I really want to learn coding. Thanks in advance

[@captainccc5151]

Nana Kwaku i don't think he will be able to contact you in private, but if you want a companion in your journey of learning how to code, you can contact me, I will help you with the best of my capabilities.

[@kacksonkirk76]

@@captainccc5151 can i contact you too?

[@captainccc5151]

@@kacksonkirk76 what do you need my friend

[@kacksonkirk76]

@@captainccc5151 i really don't understand anything. I've watch a lot of videos about normalization. My periodical exam was to make 1NF to 3NF using xampp

[@captainccc5151]

@@kacksonkirk76 I would recommend you to watch videos that explain the theory of it, maybe check out the CS50 channel on UA-cam and see if they have videos on that, their videos are usually great help.

[@nikkiblanco1489]

Thankyou!

[@nikhilkumar4892]

i m unable to insert values its giving me error that table is read only????????plaese help

[@victormamouroutraore2426]

thank you very much. Please how we build a profile system ?

[@probinsyanongbotikol7213]

i am struggling with my rental rooms project,, for school

[@makwanakartik3599]

what to enter virtuality

[@wissemansi]

MY MAAAAAN

[@JenishShrestha-i2m]

Resources
Terms & Conditions
Privacy Policy
Login
Namuna

[@lycan2494]

australian

[@buda3d2007]

TAFE it

[@creationduwal]

you really need to speak fast.

[@taudom8317]

ObamaSUS