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

[@AbantikaNayak-j6c]

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

[@CreativeSamCS]

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

[@bhagirathiverma2627]

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

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

[@mahanuzsabbo5024]

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

[@ecstatic6133]

I really appreciate your hard work
Thank u 🇵🇰

[@YahooBaba]

Your welcome :)

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

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

[@only_for_fun1234r]

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

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

[@mohsinrana7293]

jordaar sir bole to ek number

[@ganeshpardeshi1911]

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

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

[@aliyakosar6788]

U. are the best sr❤❤

[@shahzaibidreesahmed4827]

Nicely done

[@JokeAndTalk]

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

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

[@SahilservantofAllah]

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

[@adnanmalik1399]

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

[@YahooBaba]

Thanks a lot

[@Abhirup_Maiti]

Thank you so much ❤❤

[@SandipanSarkar-c8v]

Finished watching

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

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

[@wajidali3487]

GREAT

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

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

[@jaijadhav1907]

Great!! Baba

[@anshubacchal]

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

[@muhammadshababbashir6399]

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

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

[@harishazzi4874]

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

[@ParthivShah]

thanks.

[@safiawali78]

Good

[@narendrajangid5175]

Mja aa gya sir
Very nice
Thanks

[@YahooBaba]

Your welcome :)

[@dhruvrajsinhjadeja-vfxarti3085]

Awesome sir

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

[@sabkuch2400]

Sir I m yr big fan

[@YahooBaba]

Thanks :)

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

[@rockjohn1563]

It should be Personal and city table

[@hiteshdesale5152]

Best 👍

[@YahooBaba]

Thank you so much 😀

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

[@anilbadgujar6685]

Good job

[@YahooBaba]

Thanks Anil :)

[@zoyakhatun191]

Thanks sir

[@YahooBaba]

Welcome

[@FebShorts]

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

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

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

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

[@rajaneeshray7502]

good

[@YahooBaba]

Thanks

[@SaimAli-rg7oc]

Sir es ka real ma koi use huta ha

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

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

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

[@dipakdubey1]

Sir php shikhne ke liye MySQL shikhna jaruri hai

[@YahooBaba]

Bina MySQL ke PHP ka koi use he nahi hai.

[@dipakdubey1]

@@YahooBaba thanku sir

[@kvnagendra5354]

What about FULL JOIN

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

[@shubhamdpatil]

NULL and 0 are different
0 is not a null value

[@YahooBaba]

Yes you are right

[@Aaron-ro1ln]

🇧🇩🇧🇩

[@DeepakJindal07]

Foreign key zaroor nahi hai waise.

[@YahooBaba]

No foreign key zaroori nahi hai but primary key hai

[@ajeetverma3936]

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

[@gauravdwivedi6966]

Oct 2023 2 monts left to 2024

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

[@SandipanSarkar-c8v]

Finished watching