MySQL LEFT JOIN & RIGHT JOIN Tutorial in Hindi / Urdu

In this tutorial you will learn mysql left join and right join tutorial in Hindi, Urdu.You can learn how to get selected data from two tables with mysql left join and right join in hindi.
PHP Tutorial in Hindi Playlist
• ✅ PHP Tutorial in Hind...
MySQL Tutorial in Hindi / Urdu Playlist
• 🥇 MySQL Tutorial for B...
Official Website
www.yahoobaba.net/
Follow us on Facebook
/ yahooobaba
Follow us on Twitter
/ yahooobaba
#mysql #webdevelopment #php

[@user-nt7jm2mo2o]

Sir, I purchased a PHP course from Udemy but struggled to understand it. However, you clarified it easily. Thank you so much sir. Thank you a lot. 🙏 Very helpful video sir.

[@yugpatel2759]

Seriously sir.....you are amazing teacher.....in the past i have too much douts on database..but whan i show your all tutorial then all douts will become solv .....your teaching techniques and symple language i liked 👍.. thanks sir

[@YahooBaba]

Glad to hear that... Thanks and Welcome :)

[@wick_bourne]

For future viewers, those who are getting ERROR1366 should instead manually type 0 instead of leaving things as it is in order to obtain null value.

[@imtiyazbagwan6770]

Thanks

[@nadeem1721]

Thank you bro!! 🙂

[@_Alone_Mast]

But why I can't leave it null ?

[@katariyakhushbu2244]

Please share specific video link...

[@wick_bourne]

@@katariyakhushbu2244 It is self explanatory.

[@JCFitness8]

Thanku sir
Bought course on Udemy but didn’t understand it
But you made it clear easily🙏🏻

[@YahooBaba]

Glad to hear that

[@bhagirathiverma2627]

Thanku sir for this informative video 😀😊😊🙃🙃🙃🙂🙂🙂😇😇😇😇😇☺☺☺

[@mohsinrana7293]

jordaar sir bole to ek number

[@JokeAndTalk]

Thanks sir very helpful for me❤️❤️❤️

[@mahanuzsabbo5024]

your video is really helpful. Thank you for making such videos.
please make videos on programming language on java .

[@aliyakosar6788]

U. are the best sr❤❤

[@adnanmalik1399]

sir you are great, keet it up. may God bless you

[@YahooBaba]

Thanks a lot

[@ecstatic6133]

I really appreciate your hard work
Thank u 🇵🇰

[@YahooBaba]

Your welcome :)

[@dhruvrajsinhjadeja-vfxarti3085]

Awesome sir

[@only_for_fun1234r]

All ur video are aawesome ,but this part is little difficult to understand when you use settings in mysql

[@Abhirup_Maiti]

Thank you so much ❤❤

[@shahzaibidreesahmed4827]

Nicely done

[@jaijadhav1907]

Great!! Baba

[@basaratali92]

in the case of LEFT JOIN, the left table to consider before LEFT JOIN and the right table will be considered after LEFT JOIN. In RIGHT JOIN, the right table to consider after writing RIGHT JOIN and LEFT table will be considered before writing RIGHT JOIN. Why?

[@ganeshpardeshi1911]

sir can u give us these all notes that you are showing in your videos pdf format. please ..
and nice tutorial sir ..

[@narendrajangid5175]

Mja aa gya sir
Very nice
Thanks

[@YahooBaba]

Your welcome :)

[@harishazzi4874]

thnksssss.......😘😘😘😘😘😘😘😘😘😘

[@amigosfriends2104]

Respected towards yahoo baba n family..
I hope you are doing good.. Respected sir my concern is that I want that user can create their own table buy their own name..
How it can be possible although I tried it by the following..
$REQUEST[ ] which holds the dynamically name of table by the user...
Kindly reply accordingly..
Thanks

[@hamsejaban204]

good of course but it was hard to make that “modern soft”. I’ve heard many great tNice tutorialngs about soft soft throughout the years and finally

[@CreativeSamCS]

Salaam Sir I have no edit option to edit city column in MySQL workbench .Please guide how can I enable it.

[@user-lm5wb8vi1x]

Finished watching

[@sabkuch2400]

Sir I m yr big fan

[@YahooBaba]

Thanks :)

[@muhammadhumza117]

sir i am confuse u said we foreign key to use joins but in this video u remove the foreign key but the joins working properly

[@ParthivShah]

thanks.

[@anilbadgujar6685]

Good job

[@YahooBaba]

Thanks Anil :)

[@safiawali78]

Good

[@manishkushwaha-je6xy]

sir I have a question
jaisa ki apne bataya hai ki
ON ke bad foreign key = primary key use karte hai
lekin apne foreign key ko delete kar diya fir ye kaise work kar rahi hai
samjh me nhi aa raha hai
sir plzzzz reply.

[@hiteshdesale5152]

Best 👍

[@YahooBaba]

Thank you so much 😀

[@zoyakhatun191]

Thanks sir

[@YahooBaba]

Welcome

[@usamaansari7903]

but sir 10:00 mai humne foreign key hata di thi or 0 value save kardi and aap ne run kardiya direct tho without foreign key kaise batarahai

[@shashankvashishtha4454]

Same doubt

[@anshubacchal]

बीच-बीच में ये दूसरे operation perform नही किया करो, जैसे इसमे आपने update और दूसरे... work किया है. इससे concentrate हट जाता है

[@sgouri3519]

L:_ove u sir
I know html css little JavaScript
Should i learn php also to do job in any company??
And html css javascrip and php is enough to get job???

[@YahooBaba]

Yes it is enough to get a job as a web developer.

[@rajaneeshray7502]

good

[@YahooBaba]

Thanks

[@anonymous36998]

But sir one question: if we remove foreign key then how can even both the table join with each other...off course foreign key is a way to make a bridge 🤔

[@YahooBaba]

Hello Pratik, here one thing i want to tell you that foreign key is not compulsory to make join but Primary key is compulsory.

[@anonymous36998]

@@YahooBaba when we created table we wrote foreign key (city) referenced city(cid)...can we create the same scenario without writing foreign statement?

[@YahooBaba]

No

[@muhammadshababbashir6399]

Their is a problem in my tables city is varchar and id is int how can we we forign key ??

[@brandcutpiecehouse]

sir, order by command main data ascending order main hota ha agar data descending order main chahiya tu kia karain

[@ujjwalshrivastava7922]

Order by column name and desc

[@AnujGupta-kw9sw]

Order by column_name DESC ;

[@chiragmer5336]

Mera Question javascript kaa he
Hamare paas A+B+C variables hee or tino ki value same he to....
If Condition me kya axicute hooga
Pls deep me samjana....

[@YahooBaba]

Chirag mujhe aapka Question samajh nahi aaya. If condition mein aap kya condition bana rahe ho ?

[@chiragmer5336]

@@YahooBaba condition a he ki 3 variyable liye he a, b, c, or uski valu pata nahi he to condition a he ki tino ki valu same aaye to if condition me jo he o print ho.

[@chiragmer5336]

Valu daynamic he jo pata nahi he to iske liye kya logic he

[@rockjohn1563]

It should be Personal and city table

[@sagar3861]

sir aapney idher foriegn key use kari haa but news waley project mae nahi kari??? join ka sath FK zaruri hoti sir?

[@YahooBaba]

Foreign key use karni zaroori nahi hoti hai lekin Primary key jaroori hai Table join ke liye

[@amafhhcoding]

@yahoo baba sir aapne city name ka jo column tha usme se foreign key kyu hataya plss explain me

[@FebShorts]

I run this quarry but I got all null in right table data!!!!

[@ghameshsiyag]

sir jab mai jaise aapne inbuild ka use karke edit kiya hai to mai esa karta hu mera software automatic band ho jata hai workbeanch esa kyu?

[@YahooBaba]

Aise koi problem maine toh nahi dekhi hai. Aap google pe find out kareye.

[@aviruletiwari]

Sir certificate karna jaruri hai MYSQL me job k liye? Maine sql pe 2yr kaam kiya hai but koi certification nhi hai?

[@YahooBaba]

Certificate ki koi jaroorat nahi hai MySQL ke case mein.

[@aviruletiwari]

@@YahooBaba ok sir thanks for yoyr videos on mysql

[@mobeennomani7614]

sir record insert karate waqt primary key lagane se duplicate entry ka error a jata ha

[@YahooBaba]

Entry ke time pe Primary key wale column mein value nahi daalni hai woh apne aap generate hogi.

[@Goodluck0066]

Sir primary key or foreign key banana compulsory hai

[@YahooBaba]

Primary Key compulsory hai lekin Foreign key nahi.

[@najamhassan3931]

Ek PHP developer ko Kia Kia ana chye agr wo khi php developer ki job k ly jye tu. Plz guide sir

[@YahooBaba]

PHP Developer ko kuch specific cheeze jaroor aani chahiye hai :
1) MySQL with PHP
2) Ajax and JSON
3) API Development
4) PHP Framework like Laravel and Codeigniter

[@najamhassan3931]

@@YahooBaba thank you so much

[@vatsvlogs6110]

Mysql server mei kyun nahi krr rahe sir..🤔

[@kvnagendra5354]

What about FULL JOIN

[@khan.hassan]

Agr humne FK foreign key remove krdi ha to data show q ho raha ha?

[@YahooBaba]

Because FK is not necessary. The necessary is PRIMARY Key.

[@दीपक1234]

Sir php shikhne ke liye MySQL shikhna jaruri hai

[@YahooBaba]

Bina MySQL ke PHP ka koi use he nahi hai.

[@दीपक1234]

@@YahooBaba thanku sir

[@Aaron-ro1ln]

🇧🇩🇧🇩

[@SaimAli-rg7oc]

Sir es ka real ma koi use huta ha

[@basaratali92]

I have a question, it's funny but it's a question. why did you give your channel name "Yahoo Baba"? what is the thinking behind this name? 😅

[@YahooBaba]

Actually I was looking for unique name with domain name. Before this name I have some other names in my mind but their domain name is not available then I came up with new idea. I took two popular websites name "Yahoo" and "Ali Baba" then I combined them to make "Yahoo Baba".

[@basaratali92]

@@YahooBaba great

[@shubhamdpatil]

NULL and 0 are different
0 is not a null value

[@YahooBaba]

Yes you are right

[@karanaloria4449]

Sir jb FOREIGN KEY ki jarurat hi nhi hai to hum use syntax main likh kyu rhe hai??

[@YahooBaba]

Foreign key ka use karne ke baad jo hum JOINs lagate hai wo jyada secure hote hai aur yeh ek achi practice bhi hai ki aap Primary key aur Foreign key ka use jaroor karein agar aapko JOIN lagana hai toh.

[@karanaloria4449]

Thank u Sir.

[@vinodverma-ui2ct]

Sir isme hmne foreign key ko to remove krdiya to join kaise hogya ye table sir

[@YahooBaba]

JOIN karne ke liye Foreign key ka hona jaroori nahi hai. Hum bina Foreign key ke bhi joins lara sakte hai.

[@vinodverma-ui2ct]

???

[@vinodverma-ui2ct]

Sir foreign key ka to kaam hi na h frr

[@divyapandita790]

its not working ... at 8.21 min. wala chiz.... help me

[@YahooBaba]

Kya koi error aa rha hai ?

[@divyapandita790]

@@YahooBaba yes ... can u send me your email .. so that i can send you the screenshort Its of 22nd playlist (left join)

[@YahooBaba]

My email id : [e-mail]

[@DeepakJindal07]

Foreign key zaroor nahi hai waise.

[@YahooBaba]

No foreign key zaroori nahi hai but primary key hai

[@shubhamrane9801]

ERROR 1366: 1366: Incorrect integer value: '' for column 'CITY' at row 1
SQL Statement:
UPDATE `student`.`personal` SET `CITY` = '' WHERE (`ID` = '6')

[@YahooBaba]

See 'ID' column is of INTEGER Datatype and you can't pass its value in Quotes like this '6'. Remove the Quotes.

[@prachiagrawal2381]

@@YahooBaba sir that's the error statement showing in screen and same error comes every time I tried to get null value.

[@dante421]

@@prachiagrawal2381 when you edit the value set the value as 0 dont leave it blank, you will not get the error

[@AdityaKumar-nf5ek]

@@dante421 thanks bro this help !

[@usamaansari7903]

sir aap core java adv java bi start kariyee plzz, aap ko explanation bauth acchi hai sir aap ka watsapp no. share karo [e-mail] ispar meko

[@ajeetverma3936]

Kon kon 2022 me dekh rahe hai ....😊😊

[@gauravdwivedi6966]

Oct 2023 2 monts left to 2024

[@technicalanalytics1391]

Dear sir i m getting the below error
Operation failed: There was an error while applying the SQL script to the database.
Executing:
UPDATE `student`.`KIRAK` SET `CITY` = '' WHERE (`ID` = '1');
ERROR 1366: 1366: Incorrect integer value: '' for column 'CITY' at row 1
SQL Statement:
UPDATE `student`.`KIRAK` SET `CITY` = '' WHERE (`ID` = '1')

[@YahooBaba]

Dear remove the (") double inverted quotes before WHERE clause.

[@khushalagarwal45]

@@YahooBaba still the error is coming sir

[@user-lm5wb8vi1x]

Finished watching