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 👍

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

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

[@LaxmikantBhumkar]

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

[@mhammadshehrozkhantariq4936]

zaberdast sir mind blowing super bhot acha samjhaya hai ap nay

[@YahooBaba]

Thanks :)

[@santoshtmustudent3905]

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

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

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

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

[@mueezwani8629]

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

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

[@allaboutit-4023]

Your explanation is osm... Tysm🥰

[@timetraveler3901]

brilliant teaching sir.....💕

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

[@samayjain6695]

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

[@YahooBaba]

Thanks for appreciating my work :)

[@yt.kiran12]

no one can teach better than this.. 🧡

[@YahooBaba]

Thanks for appreciating my work :)

[@aishwaryapatil7897]

GREAT sir ji👏🏻👏🏻🙏🏻😁

[@riyabhargava8544]

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

[@YahooBaba]

Thanks :)

[@looserwinner329]

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

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

[@mdsarfarazalam8432]

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

[@accoustic_junction]

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

[@SUNILSINGH-d2i7w]

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

[@kaifhussainshaikh7312]

your teaching skill are best

[@YahooBaba]

Thanks a lot

[@bilalhassankhan221]

Excellent way of teaching..

[@varunjain3756]

Very well explained mysql Primary Key and Foreign key

[@YahooBaba]

Thanks :)

[@bhagirathiverma2627]

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

[@YahooBaba]

Most welcome

[@ananyaputatunda8108]

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

[@YahooBaba]

Glad it was helpful!

[@Akshay_1008]

very good explanation 🎊🥰

[@aayanmansoori7328]

Finally personal table replace hogayi🥳🥳

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

[@devgajjar7526]

Excellent explanation sir

[@YahooBaba]

Thanks for liking

[@sakshampathania9897]

THANKS SIR FOR THIS VIDEO IT REALLY WORK

[@YahooBaba]

Your most Welcome :)

[@Ababeel-h9i]

Brilliant sir...

[@Ravin2313]

thank you for this useful videos

[@YahooBaba]

You are welcome

[@ramanrajputindian5974]

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

[@YahooBaba]

Thanks and welcome :)

[@someshsahu4638]

nice video thankyou

[@forexspectrum4799]

Awesome sir 👍😎

[@godbhaigod]

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

[@DeepakGupta-hj2dv]

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

[@Shivam_K8468]

bhut achha bhut khoob

[@YahooBaba]

Thanks and welcome :)

[@mohitranjan1719]

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

[@mdsir7520]

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

[@YahooBaba]

Your welcome :)

[@sandeepkumar-web]

Great brother nice job

[@YahooBaba]

Thank you so much 😀

[@nilanjankarmakar-h3t]

Sir, i am getting the error ----16:20:40 CREATE TABLE STUDENT2 ( ID INT NOT NULL AUTO_INCREMENT, NAME VARCHAR(50) NOT NULL, AGE INT NOT NULL, CITY VARCHAR(50) NOT NULL, PRIMARY KEY (ID), FOREIGN KEY (CITY) REFERENCES CITY (cid) ) Error Code: 3780. Referencing column 'CITY' and referenced column 'cid' in foreign key constraint 'student2_ibfk_1' are incompatible. Could you please help?

[@adityabisen2362]

i am also getting the same error.

[@hindivaleengineer9843]

bhai solve ho gya ho to btaa de yrr

[@Excelwithajit8145]

Very nice sir

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

[@vijay_madane03]

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

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

[@varungoyal2827]

sir your all videos are awesome ad you are doing great job, but in this video i felt it needed more explanation.

[@manangrai]

MySQL optimization ka video bhi bna lijiye sir

[@YahooBaba]

Sure

[@Sonam_Bind_Vlogs]

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

[@ragnershadat6608]

I am getting the same error. any solution?

[@ragnershadat6608]

kzbin.info/www/bejne/ioHMmGRja9Khf6M

[@Sans_K5]

thanks_Sir💜

[@mnmelodious9411]

Any one nowadays ❤

[@Rahul-tf6vx]

Make one more video on primary and foreign key

[@manasdas9461]

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

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

[@stayclassy6609]

Helpful ❤️

[@SandipanSarkar-c8v]

Finished watching

[@gauravmishra5523]

Please make a video on powerbi

[@RaheelRashid-w1m]

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

[@ashvanishukla941]

Sir python par video banyi plzz hindi ma

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

[@shrutikushawah6360]

Thank you sir

[@YahooBaba]

Welcome

[@AMITKUMAR-pz2xh]

Excellent

[@CS_HimanshuVishwakarma]

I think these people are more intelligent than me

[@AbdulBariEkshaikh]

Make video on postgresql

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

[@sandeepkumar-web]

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

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

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

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

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

[@almamunkhan6107]

thank you sir...

[@YahooBaba]

Most 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

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

[@Thecryptoman9]

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

[@YahooBaba]

Aila...kaise ?

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

[@vikaspatel1521]

The insert statement conflicated with the foreign key the conflict occured in database table column

[@muhammadzeeshanwasi250]

Nice explain

[@YahooBaba]

Thanks and welcome

[@sanjayparmar3824]

Thanks for

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

[@mintugaur6584]

Sir very nice lec please share pdf

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

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

[@riyatomar233]

Hello sir id auto_incrwament doesn't support in MySQL workbench

[@YahooBaba]

It supports but first you have to set the datatype of "id" is INT and also give it PRIMARY KEY. Only then it will work auto increament.

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

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

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

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

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

[@shahzaibidreesahmed4827]

Great

[@RaheemJaan-xt5cp]

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

[@mohibsoftware]

the city data type should be int sir you write varchar in student table demo nut in personal table you give int data type to city

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

[@sgouri3519]

Dear sir please make a video that how to use xamp server after created a web site by html css javascrip .

[@YahooBaba]

Coming Soon :)