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

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

[@LaxmikantBhumkar]

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

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

[@santoshtmustudent3905]

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

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

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

[@kirankaur3548]

Bhut vadia treke nl clear kita sir g thanks 👍🙏

[@allaboutit-4023]

Your explanation is osm... Tysm🥰

[@mhammadshehrozkhantariq4936]

zaberdast sir mind blowing super bhot acha samjhaya hai ap nay

[@YahooBaba]

Thanks :)

[@joydeepbhattacharjee5305]

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

[@YahooBaba]

Glad you liked it

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

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

[@mueezwani8629]

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

[@timetraveler3901]

brilliant teaching sir.....💕

[@accoustic_junction]

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

[@ramanrajputindian5974]

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

[@YahooBaba]

Thanks and welcome :)

[@looserwinner329]

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

[@kaifhussainshaikh7312]

your teaching skill are best

[@YahooBaba]

Thanks a lot

[@samayjain6695]

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

[@YahooBaba]

Thanks for appreciating my work :)

[@bilalhassankhan221]

Excellent way of teaching..

[@MindPowerOfHuman]

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.

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

[@ananyaputatunda8108]

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

[@YahooBaba]

Glad it was helpful!

[@Ababeel-h9i]

Brilliant sir...

[@bhagirathiverma2627]

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

[@YahooBaba]

Most welcome

[@Akshay_1008]

very good explanation 🎊🥰

[@varunjain3756]

Very well explained mysql Primary Key and Foreign key

[@YahooBaba]

Thanks :)

[@devgajjar7526]

Excellent explanation sir

[@YahooBaba]

Thanks for liking

[@mdsarfarazalam8432]

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

[@someshsahu4638]

nice video thankyou

[@YogeshKumar-ht8dt]

sir if we are making a column primary key in existing table and that column have automatic value increment so there should not need to create that column as primary key because that column cannot accept null value and duplicate as well in SQL server.

[@sakshampathania9897]

THANKS SIR FOR THIS VIDEO IT REALLY WORK

[@YahooBaba]

Your most Welcome :)

[@forexspectrum4799]

Awesome sir 👍😎

[@Ravin2313]

thank you for this useful videos

[@YahooBaba]

You are welcome

[@aayanmansoori7328]

Finally personal table replace hogayi🥳🥳

[@SUNILSINGH-d2i7w]

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

[@varungoyal2827]

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

[@Shivam_K8468]

bhut achha bhut khoob

[@YahooBaba]

Thanks and welcome :)

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

[@sandeepkumar-web]

Great brother nice job

[@YahooBaba]

Thank you so much 😀

[@godbhaigod]

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

[@Excel_with_ajit]

Very nice sir

[@Sans_K5]

thanks_Sir💜

[@mdsir7520]

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

[@YahooBaba]

Your welcome :)

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

[@stayclassy6609]

Helpful ❤️

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

[@HimanshiChouhan-y3m]

Have you resolved the problem..? Can you please tell me

[@AMITKUMAR-pz2xh]

Excellent

[@SandipanSarkar-c8v]

Finished watching

[@kavitasharma-yr2gc]

Auto increment ke sath primary key write kr skte h?

[@shahzaibidreesahmed4827]

Great

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

[@DeepakGupta-hj2dv]

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

[@shrutikushawah6360]

Thank you sir

[@YahooBaba]

Welcome

[@almamunkhan6107]

thank you sir...

[@YahooBaba]

Most welcome

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

[@kavitasharma-yr2gc]

Aur not null compulsory to NhI likhna Auto increment ke sath ?

[@mohitranjan1719]

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

[@vijay_madane03]

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

[@sanjayparmar3824]

Thanks for

[@muhammadzeeshanwasi250]

Nice explain

[@YahooBaba]

Thanks and welcome

[@manangrai]

MySQL optimization ka video bhi bna lijiye sir

[@YahooBaba]

Sure

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

[@RaheelRashid-w1m]

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

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

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

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

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

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

[@mnmelodious9411]

Any one nowadays ❤

[@manasdas9461]

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

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

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

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

[@Rahul-tf6vx]

Make one more video on primary and foreign key

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

[@vikaspatel1521]

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

[@gauravmishra5523]

Please make a video on powerbi

[@sanjayparmar3824]

Good

[@YahooBaba]

Thanks

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

[@RaheemJaan-xt5cp]

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

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

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

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

[@theroshan1697]

I am unable to create table which includes primary and foreign key....everything is OK.. but still it is showing error like foreign key incorrectly formed..

[@YahooBaba]

Its mean that your foreign key is not correctly connect with Primary key of another table.

[@basharat2524]

Sir ye error a rha ha raat ka phpmyadimn mea Cannot add foreign key constraint

[@YahooBaba]

Error toh SQL command mein hai wo dikhayiye

[@basharat2524]

@@YahooBaba sir corrcet ker lya hai after 6hr

[@storybox1234]

@@basharat2524 how?

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

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

[@CS_HimanshuVishwakarma]

I think these people are more intelligent than me

[@AbdulBariEkshaikh]

Make video on postgresql

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