MySQL JOIN Multiple Tables Tutorial in Hindi / Urdu
In this tutorial you will learn mysql joins multiple tables tutorial in Hindi, Urdu.You can learn how to join more than 2 tables in mysql 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
Пікірлер: 152
Kamal ka samjhaya....koi bhi easily samjh jayega
Thanx a lot sir, this is great channel I've ever seen in KZread
Best way to learn SQL. Great teaching skills thanks a lot .
@YahooBaba
2 жыл бұрын
Thanks and welcome
Im taking help from your videos for my final year project. Thanku soo much for sharing such content
@YahooBaba
3 жыл бұрын
Glad to hear that 😊
@HarshadChavan1830
11 ай бұрын
@@YahooBaba bhai department konsi hai
from today I am starting to make job portal for my practice and was confused how to join multiple tables and this helps me thanks.
@YahooBaba
2 жыл бұрын
Your welcome :)
Very beautifully explained. Thanks
Kaafi mehnat lagti aise videos banae me aur itna clear padhane me..respect sir
@YahooBaba
3 жыл бұрын
Thanks and welcome :)
wao .sir mujhay joining kabhi samujh nhi eye lkin apkay lecture kay bad sub kuch samugh may aa giya
Thankyou so much sir your video is too amazing every consept are cleared....
@YahooBaba
2 жыл бұрын
Your welcome :)
Thank you sir very helpful video for me
Thank you sir making for such these kinds of videos ..
@YahooBaba
4 жыл бұрын
I'm glad you like it :)
Tnx bro
best video so far
Sir u r great teacher
thank you sir🙃🙃😊😊😊🙂🙂🙂😇😇😇😇
Best course... I just continuously watching from last 3 days 😊 and soon full complete the course 😊
Thank you so muchhhhh sir..... this means a lot to me........keep growing sir ji............🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
@YahooBaba
Жыл бұрын
Most welcome
Awesome sir...
Thank you sir
php print "thank you soo much, it is very helpfull.
@YahooBaba
Жыл бұрын
Glad it was helpful!
Sir very nice
very nice sir.sachi bahar se course kiya to kuch ni samjhaya aise deeply.confused rehti thi. k yeh kaise krna hai tab tk toh course bhi bnde ka khtm hone ko ajata hai.mujhe lga mera hi dimag kam hai :P .sir se puchti thi apko kaise PHP agai samnjh.pr apki videos se 5 min mein itna achi trh se smjh ata hai k bnda khud krle solve fir. thankyou so much.
@YahooBaba
4 жыл бұрын
Thanks Tanu for appreciating my work :)
Totally clear y Al topics thanks so much
@Zerocoment-zh6bq
Ай бұрын
Zaida clearkrta ha toh shadi kr loo is sy ..... Or sex krty wqt bee yehe smja kro.
o bhai bhai bhai kya samjhaya hai yaar aapne bahut bahut shukriya
@YahooBaba
2 жыл бұрын
Thanks and welcome :)
Tnx vai
Today is anice day for Me..Thanks Sir
@YahooBaba
3 жыл бұрын
All the best
Wooow great explanation 👌👌👌
@YahooBaba
Жыл бұрын
Glad you liked it
Very good Explanation 👍👌
@YahooBaba
4 жыл бұрын
Thanbks Naresh :)
Thanks
acha sikha rahay hai thumps up dear
@YahooBaba
4 жыл бұрын
Thanks khawar :)
Nice and easy explanation 🎉🎉🎉🎉
@YahooBaba
2 жыл бұрын
Thanks a lot 😊
is there is any posibility to set the execution time like in js we use settimeout and thanks for making this series sir !!!!
@YahooBaba
8 ай бұрын
Yes you can do this with the help of "EVENTS" in mysql. Read this article for that : stackoverflow.com/questions/38886839/how-can-i-run-a-query-in-a-specific-time-using-mysql-or-php
@user-kc8sh3rr5e
8 ай бұрын
@@YahooBaba Thanks its really helps !!!
Awesome sir :)
@YahooBaba
4 жыл бұрын
So nice of you
thanks.
many many thanks
@YahooBaba
2 жыл бұрын
You are most welcome
awesome
very good explanation
@YahooBaba
3 жыл бұрын
Thanks for liking
Very nice sir . Pure youtube par apke jaise koi nahi samjhata
@gauravjha7875
Ай бұрын
@@Zerocoment-zh6bq tune kar rakhi h kya???
@Zerocoment-zh6bq
Ай бұрын
@@gauravjha7875 ap ke behan sy ? G ap salay ho meray ..... You don't know ... ap shadi per bee aye thy .... I have fucked your sister ... when we both are in mood . Ufff what's the feeling that your sister gives me ..... She is very good .
@Zerocoment-zh6bq
29 күн бұрын
@@gauravjha7875 teri behan ky sath, shadi ke hue ha ..... Uff your sister is too much beautiful... I fucked her when we both are in mood. You can't imagine that how we are satisfied. She love me... she give me satisfaction by her gorgeous body, when i am in tension. Bus yrr kia bataon rateen kitne haseen or din kitnay rooshan hoty hain us ky sath, jab woh meray or ma us ky kapray utarty hain.
@Zerocoment-zh6bq
29 күн бұрын
@@gauravjha7875 sala ha tu mera sharam kr.....
Thank u sir Sir aap video editing kese karte ho ye sav explain karne k liye ?
Best teacher
@YahooBaba
2 жыл бұрын
Thanks and welcome :)
nice teach
2:00 Sir u said humne in Cid ko save kraya h Student table me to sir save kaise kraya h ,if Inner Join se save kraya h to hum select command laga ke saare columns dekh skte hain to fir prblm kya h
thank you sir: this is my MySQL statement : SELECT courses.coursename,courses.Fee,COUNT(students.courid) FROM students INNER JOIN cities ON students.cities=cities.enrollno INNER JOIN courses ON students.courid=courses.courseid GROUP BY students.courid ;
Sir ap ke OOP ke concerpts mujhe ache lage lakin ap MySQL ki jaga phpmyadmin pr videos bana the to bohat acha hota
@YahooBaba
3 жыл бұрын
Fazal mujhe lagta hai aapko MySQL aur phpmyadmin ke bare mein pata nahi. PHPmyadmin mein MySQL ka he kaam hota hai.
City table Mai cid column aur courses table Mai crid column Ka primary key Hona jaruri hai hmra tbhi hm endono tables ko student table se join Kar skte hai ?
@YahooBaba
4 жыл бұрын
Dekhiye Primary key lagana toh jaroori hai lekin Foreign key lagana jaroori nahi hai. Primary key ek unique identity hoti hai kisi record ki.
Love from Pakistan
make series on android studio
Sir student.table doesnot exist ka error aa raha hai hala k mainay koi extra table nai banaya courses ciry aur personal k ilaawa is problem ko kesay solve kru kindly bata dain
Sir, are you going to explain oops concepts in this PHP tutorial.. please answer me
@YahooBaba
4 жыл бұрын
Yes I will explain every topic in PHP...like Oops, Ajax, Jain, API Development.
Sir ji har video ki title me video ki sr no ho sake to add kijiye 👍
@YahooBaba
4 жыл бұрын
Hello naps, maine already video ke thumbnail pay serial number dala Hua Hai.
@bapanadhikary9
4 жыл бұрын
@@YahooBaba haa sir but jab video watch karta hu tab samajme nehi ata hay is video ka sr no kaya hay fir video ko close karne ke bad thumbnail check karna padta hay
Sir why you not give Foreign key to courses column
Agr city table me cid=5 me bhi city Agra huii toh student table me Agra ke liye kaunsi id jaayegii 1or5?
@YahooBaba
Жыл бұрын
5 jaayegi.
How u added courses table in this
❤❤
sir personal table mai ek hi time pe city and couses kaise aa rahe. Apne 2 foreign key set ki hai kya personal table mai city and courses ke liye
@YahooBaba
3 жыл бұрын
That is because of JOINS
Sir category and sub-category se Product add karne pe jis category ki sub-category nahi hai wo Data Show nahi ho raha hai join category ka use karke please help me I m developing E-commerce website.
@YahooBaba
3 жыл бұрын
Usmein LEFT Join lagega.
@azadtpoint8761
3 жыл бұрын
@@YahooBaba thank you sir try krta hon
aapne personal table update kiya hai kya. Mai aapke puri series follow kar rahi hu
@YahooBaba
3 жыл бұрын
Yes update kiya hai.
Sir how to insert data from one form in multiple table's.
Nice
@YahooBaba
3 жыл бұрын
Thanks
@Abhishek-iq1es
3 жыл бұрын
@@YahooBaba ohh bhai,you are the first KZreadr who replied to me Thanks Sir You are making quality content👍🏻
@YahooBaba
3 жыл бұрын
Thanks AK for appreciating my work :)
how we set a frign key without query
hello sir i just finished your html and css tutorials . can you please tell me about any website to get projects related to html and css for practice only . Not any freelance marketpalce.
@YahooBaba
4 жыл бұрын
Hello Usman I don't know any such type of website.
Sir, To inner join,left and right join the two tables is it compulsory that one table should contain primary key and another foreign key? Without foreign key and primary key can we join the tables?
@YahooBaba
3 жыл бұрын
Yes Primary key are must to make JOINS in two or more tables but you may leave Foreign keys because it is not necessary to make foreign key.
@pranalisuryawanshi491
3 жыл бұрын
@@YahooBaba OK Sir.. Thanks For your immediate reply...
@Ram-Naresh
2 жыл бұрын
@@YahooBaba Jb without foreign key kam chal jayega to hm use kyon krte hain sir??
@khushiagarwal106
2 жыл бұрын
@@Ram-Naresh kyuki hme data redundancy nhi chaiye isliye hum foreign key use krte hai and readibility shi hoti h agar Fk hoti h to🙂
@Ram-Naresh
2 жыл бұрын
@@khushiagarwal106 Thanks for reply but foreign key me data repeat ho sakta hai..
Personal table ke courses cOlumn ko Foreign key bnana padega ki nahi
@YahooBaba
2 жыл бұрын
Bana bhi sakte kyu ki koi compulsion nahi hai Foreign key banana. Han lekin Primary key banana jaroori hai.
@RECREATIONVDO
2 жыл бұрын
@@YahooBaba thanks
text editor??
how to print same but whose age is min, so just one row should be there whose age is 19
Please reply fast it's urgent... After doing all data hi visible nhi ho raha h I mean join ho raha h but rows create nhi ho rhe h. Maine jo 5 tables the unme data fill kiya h 3 rows h sabme but join me data q nhi aa raha h...?
@YahooBaba
2 жыл бұрын
Iska matlab hai ki join theekh nahi lagaya hai.
@anjuvishwas309
2 жыл бұрын
@@YahooBaba I used inner join..
sir suppose i want only btech student data table in that join how to write query
@YahooBaba
4 жыл бұрын
Show me your attempt of SQL command... I will correct it if it is wrong
@makrandshinde3435
4 жыл бұрын
@@YahooBaba SELECT p.id,p.name,p.per,p.age,c.cityname,cr.course_name FROM personal p INNER JOIN city c ON p.city=c.cid INNER JOIN courses cr ON p.courses=cr.course_id; that's my join query ,after joining three table I want show only Btech course student, where to write WHERE clause statement
@YahooBaba
4 жыл бұрын
put WHERE clause at the end of the query.
@makrandshinde3435
4 жыл бұрын
@@YahooBaba Yes its working, thank you sir.
4 table add krne pr "warning truncate ur data" likh k ata hai
sir ek table me 2 foreign key ko add karne ki Query alter command se
@YahooBaba
2 жыл бұрын
ALTER TABLE ORDERS ADD FOREIGN KEY (column1) REFERENCES CUSTOMER(SID), ADD FOREIGN KEY (column1) REFERENCES CUSTOMER(SID2);
HELP!!!!!!!! PLEASE SIR.... SIR problem ye hai ki ... hamara jo table hai i.e personal, to sir ye table 2 foreign keys ko store kar raha hai i.e cid and course_id question ye hai ki inke values ko aapne 1,2,1,2,1,,2,3 kyu likha jabki city ke table mein 5 city ke name hai...???? aur sir hame to pata nahi ki kaunsa banda kis "" cid """ se hai to hum randomly personal table k cid column mein values kyu bhar diye??? question 2 : table mein same id ko 2 baar likh diya maine like 1,1,2,3,2 then isko update kaene mei bahot dikkat aa rahi hai.please help kariye!!
@YahooBaba
Жыл бұрын
Answer 1 : Dekho personal table mein cid and course_id isliye save kiye hai kyu ki personal table heavy na ho jai. Agar usmein pura city name likhenge toh wo table heavy hota jayega. Tabhi wha sirf unique id save kiya hai aur usko show karne ke liye JOINs ka use kiya hai. Answer 2 : Dekho table banate time mein he id column ko aapne UNIQUE set karna hai taki id duplication na ho. Aap CREATE Table aur Constraints wala video dubara dekhiye. kzread.info/dash/bejne/enWLs9dumtvFaLw.html
@lachhamanrajbanshi2862
Жыл бұрын
one more help please!!@@YahooBaba Sir bas ye samajh aa raha >>> City Column ke cid mein 1,2,3,4 id hai to phir hum aise kaise Personal table ke city column mein 1,2,3,4 put kar sakte hai... ... example >> personal table ke id=1, name=ram, city=1( yaha 1 ke jagah 2 ho sakta hai, where 1= agra and 2=delhi) city table ke cid= 1 (agra), 2 (delhi), 3 (mumbai), 4 (bihar). ....mujhe nahi pata ram kaha se belong karta hai... wo kaise pata chalega?? to kya mujhe personal table ke city colimn mein city table ke cid column ke 1,2,3 dekh kar values put karna hoga personal table ke city column mein ??
@YahooBaba
Жыл бұрын
Dear hum MySQL database mein kuch bhi manually nahi dalte hai. Iske liye hum kisi server side language ka use karte hai jaise PHP. Hum user ko sirf city Name dikhanyenge aur jab wo FORM save karega tab database table mein "cid" save karenge.
Good Day! have great achievements in life... i would like to contact you on social application> would you please?
Sir DBMS connection is not available error is come
@YahooBaba
Ай бұрын
That means no JOIN establish between your tables.
3rd table join kyasa hula osko to foren key pe nahi liya tha
@YahooBaba
3 жыл бұрын
Foreign key leni jaroori nahi hai JOIN ke liye. Primary Key jaroori hoti hai. Waise mera suggestion he ki Foreign key leni chahiye hai for security reasons.
Equi join , self join ..plz
@YahooBaba
4 жыл бұрын
In MySQL their is no Equi Join and also their is no self join in mysql we do it with Inner Join or Left Join
How to see students from agra and delhi together
@YahooBaba
3 жыл бұрын
use IN operator : kzread.info/dash/bejne/mGVrus1titOzpbw.html
Sir foreign key use nahi ki he kya isme??
@YahooBaba
Ай бұрын
Hanji nahi ki hai
@vijay_madane03
Ай бұрын
@@YahooBaba Bina foreign key table access hota he kya Sir?
How to make multiple Foreign Keys ?
@YahooBaba
2 ай бұрын
In the same way as we create a single Foreigh key.
@Nature-tj1ce
Ай бұрын
@@YahooBaba Thankyou
sql ke yeah notes milege sir
@YahooBaba
2 жыл бұрын
Get it from our website www.yahoobaba.net
@UjjwalSharma-fl6fv
2 жыл бұрын
@@YahooBaba sir isme aapki bas video hai notes nhi hai
Foreign key dono table me nai ho rhai sirf city vale table me ho rahi he Or courses me karte he to error aarha he error: 150 foreign key constraints is incorrectly formed How to fix this poz any one reply
@YahooBaba
4 жыл бұрын
Paste your SQL command here... I will tell you the error
Sir whatsapp number dijiye
@YahooBaba
Жыл бұрын
Whatsapp number toh main share nahi karta hun kyu ki thoda busy hota hun development ke kaam mein, lekin aap mujhe email kar sakte hain hello@yahoobaba.net