MySQL PRIMARY KEY & FOREIGN KEY Tutorial in Hindi / Urdu

[@ThisAmit]

You are remarkably talented in how to teach step by step. Proper visualization. I'll say perfect.

[@amitdandagavhal7730]

perfect explanation, im a non IT guy but understand it very easily ...worth to watch this series.

[@YahooBaba]

Good 👍

[@poojaghodke4552]

Thanks for the great videos as the content is very understandable, accurate and concise way quick to brash up the concepts

[@YahooBaba]

Glad you like them!

[@arijitbhakta9705]

One of the best YT channel to learn programming

[@codingbyyash1948]

Never seen such a excellent explanation.........

[@YahooBaba]

Thanks for appreciating my work :)

[@khatariinsaan5284]

Yes u are absolutely Right !!

[@guscolt2057]

I know it is quite randomly asking but do anyone know of a good website to watch new series online ?

[@ROHIT-sk3ox]

@@guscolt2057 alt Balaji

[@CS_HimanshuVishwakarma]

Acchha samajh Gaya bhai ko bahot shi

[@santoshtmustudent3905]

I will never forget this explanation Your teaching skills are soooooooooooooooo goooooood sir Thank you 🙏

[@LaxmikantBhumkar]

Easiest way to learn _primary-foreign_ key. Thanks sir👍

[@mhammadshehrozkhantariq4936]

zaberdast sir mind blowing super bhot acha samjhaya hai ap nay

[@YahooBaba]

Thanks :)

[@mueezwani8629]

perfect example sir....... thankyou sirr...

[@divyanshubse]

Nice explanation by yahoo baba full return of time. In college teacher takes fees and waste more time of students. You are great yahoo baba❤❤

[@YahooBaba]

Thanks a lot

[@meenu9981]

Bohot hi mahol padhate ho sir ji aap.. 1st time apki video dekhi.. n I m ur fan... Bohot easy Way se sikhate ho..

[@YahooBaba]

Thanks for appreciating my work :)

[@kirankaur3548]

Bhut vadia treke nl clear kita sir g thanks 👍🙏

[@rahul2gautam]

I watched many videos, but was not clear, but you have explained it very well just like my ORACLE Teacher when i was in Collage, Thanks

[@YahooBaba]

Glad it was helpful!

[@joydeepbhattacharjee5305]

lovely explanation...to the point video... respect ++

[@YahooBaba]

Glad you liked it

[@allaboutit-4023]

Your explanation is osm... Tysm🥰

[@riyabhargava8544]

i am following your whole tutorial playlist for sql . it is really nice

[@YahooBaba]

Thanks :)

[@RandomlyWisdom]

Your pitch of voice is very pleasant to hear. Explained Perfectly for beginners.

[@YahooBaba]

Thanks for appreciating my work :)

[@MohdIrshad-ko6bd]

Dono tables create krke img send kro kar do sir plzz glt ho raha hai

[@aishwaryapatil7897]

GREAT sir ji👏🏻👏🏻🙏🏻😁

[@timetraveler3901]

brilliant teaching sir.....💕

[@yt.kiran12]

no one can teach better than this.. 🧡

[@YahooBaba]

Thanks for appreciating my work :)

[@samayjain6695]

sir you are such a greate techer itna aacha syd hi koi pada apaya

[@YahooBaba]

Thanks for appreciating my work :)

[@looserwinner329]

Great time I am having with this course to so much sir

[@Ababeel-h9i]

Brilliant sir...

[@accoustic_junction]

You came as blessing sir.... Thanku so much sir❤

[@kaifhussainshaikh7312]

your teaching skill are best

[@YahooBaba]

Thanks a lot

[@bilalhassankhan221]

Excellent way of teaching..

[@someshsahu4638]

nice video thankyou

[@Dark07knight]

Sir I am b.com final year student ... And now my computer professor is teaching us SQL but it's a old version by looking at your videos syntax are different... Please help me with old version sir.

[@mdsarfarazalam8432]

Hello sir store procedure pr video laye aap bahut achchhe se padhate hai

[@Jatinder_Kaur_Angel]

sir ajkl jo companies websites bna ri hai. all devices perfect hoti hai. but bootstrap se nahi hoti ya custom media quries se kro toh bhi kami reh jati hai toh pls yeh zroor bnaiye alag se video. your all videos are nice. thanx this hardwork for us.

[@YahooBaba]

Yes sure main jald hi es topic par video banaunga.

[@ramanrajputindian5974]

It's A very Good explanation for me ... ❣️ And i Can't stop my fingers to Subscribe You ❣️❣️❣️

[@YahooBaba]

Thanks and welcome :)

[@devgajjar7526]

Excellent explanation sir

[@YahooBaba]

Thanks for liking

[@SUNILSINGH-d2i7w]

yar aapki voice my god kitni mst h jaise delhi metro me bolte h

[@waqarwaqar487]

hello sir , i have questions k foreign key to point krta he dosrey table k column ko jo k apne banaya CITYNAME k name se to CITY kese foreign key bana ? 2nd yeh k apne is tutorial main personal table k column city ki values to khud insert karwayen hain .. is ko khud pick nae hojana that city table se ?

[@YahooBaba]

1) Dekho ek table ki PRIMARY KEY point karti hai doosre table ki FOREIGN KEY KO, tabhi dono table join hote hai. 2) Dekho koi bhi value apne aap insert nahi hogi kisi table mein. Yha toh basically hum khud insert kar rahe hai leking jab MySQL ko kisi langauge ke sath use karenge jaise PHP toh wha se ek aisa system banayenge ki value khud insert ho jaye.

[@bhagirathiverma2627]

Thanks a lot sir😇😇😇🙂🙂🙂🙃🙃🙃🙃😊😊😊😊😋😋😋😋

[@YahooBaba]

Most welcome

[@mohitranjan1719]

Sir g ERP SAFTWERE BNANE ME PHP KE SATH - SATH OR KON SA COURSE KI NEED HAI

[@abdeali1301]

if you Add Lecture Number in video title it will be more helpful and easy to search. thankyou

[@YahooBaba]

I already placed Video Number in the Lower Left Corner of video thumbnail.

[@Akshay_1008]

very good explanation 🎊🥰

[@ananyaputatunda8108]

The whole tutorial video playlist is the savior for me . Thank you so much for such detail explanation

[@YahooBaba]

Glad it was helpful!

[@Ravin2313]

thank you for this useful videos

[@YahooBaba]

You are welcome

[@varunjain3756]

Very well explained mysql Primary Key and Foreign key

[@YahooBaba]

Thanks :)

[@sakshampathania9897]

THANKS SIR FOR THIS VIDEO IT REALLY WORK

[@YahooBaba]

Your most Welcome :)

[@Excelwithajit8145]

Very nice sir

[@godbhaigod]

There can be set of columns that can be primary key also 👍

[@vijay_madane03]

Sir personal table me insert row me last ka 1 liya he wo kiske base me liya he . Please reply.

[@SandipanSarkar-c8v]

Finished watching

[@gurejalectures]

Student table main city column main cid ki value dynamically kesy save krwaty han

[@WPANDSEOTUTORIALS]

Yes, i also want to know Yahoo Baba sir ????

[@YahooBaba]

Woh hum nahi karate hai wo toh khud generate hoti hai agar aapne table banate time cid ko AUTO_INCREMENT set kiye hoga toh.

[@gurejalectures]

@@YahooBaba ni sir main php ki baat kr raha hon. Us main aisa agar aik table main user ka data ho or second main koi comment ya post etc... to hum phir ye command kesy likhain gy k jo user waly data main id 4 ha us ny ye comment kia ha jo second table main save ha ...... to user waly id sy kesy pata chaly ga k kis user ny kon sa comment kia ha... main dating website py kam kr raha hon

[@DeepakGupta-hj2dv]

Sir jaldi upload kro...please make as soon as possible

[@forexspectrum4799]

Awesome sir 👍😎

[@kunalkale4701]

Thanks a lot

[@Shivam_K8468]

bhut achha bhut khoob

[@YahooBaba]

Thanks and welcome :)

[@Sans_K5]

thanks_Sir💜

[@sandeepkumar-web]

Great brother nice job

[@YahooBaba]

Thank you so much 😀

[@AMITKUMAR-pz2xh]

Excellent

[@MaheshPatil-of1zy]

at 6:15 the name of column City in Student Table should be Cid which is primary key in City Table and foreign key in Student Table. Name must remain same should not changed.

[@shrutikushawah6360]

Thank you sir

[@YahooBaba]

Welcome

[@TheWorldCricketSports.]

good job

[@atishayharsola496]

sir foreign key aur primay key ka naam same hona chahiye na parent table ki primary key hi to child table ki foreign key hogi par yahan to aapne primary key CID ko banaya hai aur foreign key city leliya please explain

[@AshuKumar-kw8bi]

bhai maine 2 table banaya hua hai dono me primary key dala hua hai ab mai dono ko alter wale se foreign key banana chahta hu .bhai help kr de yar ho hi nhi raha hai

[@A_Good_Boy.]

mera bhee nahi hotha for some reason

[@sanjayparmar3824]

Thanks for

[@gauravmishra5523]

Please make a video on powerbi

[@rohanaggarwal12]

Sir why you have taken city data type in personal table as INT ? FOREIGN KEY SHOULD HAVE SAME data type as primary key of another table?

[@YahooBaba]

Because in another table "city" their is a column name "cid" whose data type is INT and that is also a PRIMARY KEY of "city" table.

[@ragnershadat6608]

Sir I am getting this error Error code:3780. Reference column 'city' and referenced column 'cid' in foreign key constraint ' personal_ibfk' incompatible. Please reply

[@harshdeepsingh759]

in student table city should be in INT that is cid and city both should have same length asa wll as same datatype.

[@shahzaibidreesahmed4827]

Great

[@learn_to_code_with_sajal]

Sir I'm getting this error : Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id), FOREIGN KEY (city) REFERENCE City (cid) )' at line 8

[@YahooBaba]

May be datatype of PRIMARY KEY and FOREIGN KEY is not same.

[@nehasingh-uz5ou]

Same error

[@CS_HimanshuVishwakarma]

I think these people are more intelligent than me

[@Thecryptoman9]

Primary key 2 column ke combination se bhi to ban sakti hai

[@YahooBaba]

Aila...kaise ?

[@Rahul-tf6vx]

Make one more video on primary and foreign key

[@mdsir7520]

thanks for every single video❤️❤️❤️🧗‍♂️

[@YahooBaba]

Your welcome :)

[@sandipsandal]

is this necessary to name of both column be same like u_name = b_rented_user => should it be u_name

[@YahooBaba]

NO

[@stayclassy6609]

Helpful ❤️

[@safiawali78]

Good

[@AbdulBariEkshaikh]

Make video on postgresql

[@tapandas9622]

Please make a project using php mysql javascript & ajax.

[@YahooBaba]

MySQL course ke bad project Shuru Hone wala PHP with MySQL

[@tapandas9622]

@@YahooBaba OK

[@manangrai]

MySQL optimization ka video bhi bna lijiye sir

[@YahooBaba]

Sure

[@RaheelRashid-w1m]

SIR MA JAB TABLE KI SETTING PRE CLICK KRTA HO WASY HI MERA MYSQL OFF HO JATA HA

[@akansha348]

Sir im having one problem… can u plz tell me that where we can use CHAR instead of VARCHAR ?

[@YahooBaba]

We use CHAR where we only want to store 1 character. For example if their is "Gender" column then we only store "m" or "f" means "m" for male and "f" for female.

[@Muhammad_Naeem662]

Sir, I'm working on a project integration with PHP via localhost (form submission/ form updation) my "submission form" step is complete but I've stucked in form updation integration with PHP,,,,, Please help me out.

[@YahooBaba]

Please follow this Playlist : kzbin.info/aero/PL0b6OzIxLPbzXPdt9pKeQXm6NoPA9MdKW

[@Muhammad_Naeem662]

@@YahooBaba Thank you so much! I have no words to thank you for helping me out. I will explore your PHP MySQL playlist after completing my MySQL playlist...... I have watched full playlist of PHP before, Recently I'm learning MySQl. By the way, Thanks a lot! Love from Pakistan...

[@YahooBaba]

@@Muhammad_Naeem662 Your most welcome :)

[@raghavendrakanoongo2331]

sir data type same reta h dono ka shuru m varchar and int bata rahe ho and baad m int int bata race ho.

[@umerimran3833]

Can you please share the whole presentation file, it will be helpful for your students. Thank you!

[@YahooBaba]

You can get it from our website : www.yahoobaba.net

[@umerimran3833]

@@YahooBaba thank you sir ❤️

[@bhushansapkal8310]

Sir altering the table is complicated since the data type of my city column in personal is Varchar and then making it a foreign key requires to change it's data type later it has messed up my table.

[@faisalmalik4988]

sir thankyou and! sir hum id ko primary na set kare tw bhi kaam chal sakta hana q.k iska koi khas kaam tw nhi hai ?

[@YahooBaba]

Nahi bina Id ko primary set karne se kaam temporary hoga kyu ki duplicacy aa jayegi aur Kisi ek column ko primary key set karna zaroori hai agar aap baad mein joins bhi karna chahte ho

[@mnmelodious9411]

Any one nowadays ❤

[@ripunjoysahariah9634]

Hi sir , If Primary key= Unique + Not Null , then there is no need to give NOT NULL as a constraint in ID column ....right ? replay Sir

[@YahooBaba]

Yes your thought is right but we can only make Primary key to any column if it is NOT NULL.

[@AshishYadav-wc9ux]

@@YahooBaba ok

[@RaheemJaan-xt5cp]

sir phpmyadmin me rollback kaam nhi kr raha is ki kia wja ho skti hy? kindly guide me

[@manasdas9461]

Iske baad ak normal ER diagram iske upr bana k relation samaja k video banna chahiye tha

[@muhammadumar4659]

kia hum (Primary Key) ID k agay nahi likh saktay like (id int not null auto_increment primary key)?

[@YahooBaba]

MySQL mein nahi likh sakte. Aisa hum Oracle mein likh sakte hai.

[@shahzadiqbal4100]

@@YahooBaba sir , koi mini projects ki site recomend kro

[@muhammadzeeshanwasi250]

Nice explain

[@YahooBaba]

Thanks and welcome

[@ashvanishukla941]

Sir python par video banyi plzz hindi ma

[@kumcoder3133]

Sir, Primary key ko keise reset kare? kyu ki jab, main first row ka 1 nom id ko delete karta hun toh ,next time fir add karta hun toh woh 2 sain start hota hain, pura table delete karna parraha hain. 0r kiya ek column main 2 foreign key bana sakte hain? so please kindly help me.

[@lachhamanrajbanshi2862]

abhi sikh gaye kya??

[@RanjanJoshi1952]

sir, frgein key aur id ko int karne par commend chal gaya. Thanks. kya ek table me do foreign key nahi banai ja sakti.

[@YahooBaba]

Yes Ek table Mein Do foreign ki Banai Ja sakti hain

[@631singh]

bro can u help I am getting error in foreign key constraint is incorectly formed

[@RanjanJoshi1952]

Sir, foreign key command kam nahi kar raha hai, kya karu.

[@pranojgonjari8657]

sir why the data type of city is taken as int in personal table

[@YahooBaba]

Because we have to save the numeric value of the city. That numeric value is "id" of the city in city table.

[@pranojgonjari8657]

@@YahooBaba thanks sir for the clearing the doubt👍

[@dhruvrajsinhjadeja-vfxarti3085]

1) sir yahi chees workbench ki jagah phpmyadmin pe banake dikhaona please usme dikat ho rahi hai 2) sir workbench software me alter table command try kiya pr nahi ho raha hi

[@YahooBaba]

Yes sure :)

[@dhruvrajsinhjadeja-vfxarti3085]

@@YahooBaba Thanks and i m waiting :)

[@sandeepkumar-web]

Yii2 framework ke videos bnaoo bhai KZbin uski videos hai hi nhi hindi me

[@mintugaur6584]

Sir very nice lec please share pdf

[@waqarwaqar487]

sir yeh chez clear krdain taake tutorial agey barhey .. inner join bhi isi se related he to aur samajh nae aega

[@YahooBaba]

Yes koi bhi join isi se realted hai.

[@codingbiding191]

Plz make a video on like_dislike php ajx... I am trying to do but can't solving the issues...

[@YahooBaba]

Coming soon.

[@codingbiding191]

@@YahooBaba thnkx

[@ricky007]

SIR yeh code run nahi ho raha hai sir usme error a raha hai

[@saurabh1627kondkar]

12:34 raam kumar and sarita kumar are struggling actors