Sir aap ko jitna thanks kiya Jaye kam hai you are great sir really you are the best teacher ever I am third year student of BBA CA and I am doing my last year project in php such a greaaaat series I got to clear my all dauts and problems because I was in covid batch but now I have various strengths to do best sooooo really really thanks to yahoo baba I am really really thanks to you sir 🙏 🙏 🙏
Sir sach main aap bohot acche tarike se matlb kya batau yar aap bohot acche se padhate ho .. actually maine aapke php javascript and css ke saare dekh playlist dekh liye ...fir muze mysql main doubt tha , to socha aapke pass hoga uska bhi playlist and what ..sir u cant believe that .maine ek hi video se saara samjh main aa gya .. salute hain sir ji aapko ❤️❣️💗
Thank you so much, bhai.. Till now I have watch so many videos of inner join but I don't understand anything but,you are the best for me becausee of your teaching method and your presentation is batter than others videos and people. Thank you so much Again Brown 👍
Hats off to you sir for such a simple way of teaching. I was doing it last night for about 3 hrs but wasn't able to learn it because the instructor wasn't doing well. Nevertheless, thanks alot.
Sir i want to ask, rdbms and sql is my exam syllabus inme se kisko pehle study karu air jisse samajh me a jaye, u r best teacher sir anse teacher college me nahi hote.
Varun we uses MySQl with any Programming language like PHP, Python to get the particular data. You can check this video what u r asking for : th-cam.com/video/S8M7V5mdSdI/w-d-xo.html
amazing make a video to show three tables data by using a foreign key example: a student that has Id 3 and the class Id 4 means 5th class how to show Id 3 class name in PHP front end ??? hope you will response soon.
Agar aap Web Designer banana chahte ho tabhi Bootstrap seekhna jaroori hai warna zaroori nahi hai. Agar aap PHP developer banana chahte ho toh Laravel seekh lijiye.
if we have to define inner join everytime after using foriegn key then can we say that foriegn key is only used for connecting tables nothing more..am i right?? correct me if i am wrong😄
if you have two tables having empid ,name years of experience, --monthly salary and --other table having attributes id and annual salary, then how can we find the emp who have --expoerince >7 years and salary >1 lakh
the column selection commands are working fine without alias: SELECT id, name, percentage, age, gender, cityname FROM personal p INNER JOIN city c ON p.city = c.cid;
For that you have to use ALTER command. You can see that ALTER video in this same course playlist and read this article to ad Foreign key to already existing table : stackoverflow.com/questions/10028214/add-foreign-key-to-existing-table
sir in my table when city name is repeated then the same name are show together and my id no are not in sequence if id no.1 and id no. 4 are having same city then 1 &4 are came together so sequence is 1,4,2,3,5,and so on plz tell me the right solution.
yahi to smj nai ati k aliasing krne se phehle hi usko use kese kr skte hain system ko kese pata chalay k ye alias kis se relted hai baqi thoery tak thek hai
Muje ek parle biskut, ek samosa lakar do deu kaka or samosa bhaiya se Aapko jis tarah pata chala same system ko bhi ese hi pata chalega Pahele use kya lana he or baad men kaha se lana he, ese system kaam karegi
1. Ya zaroori ha k hum sirf *Foreign key column* ko *Primary Key column* sa match karinga? 2. Hum 2 tables sa ziyada ka kis taran *Inner join* karinga? 3. Ap na *Aliases* karta wqt *AS* q nahi likha, os k bhagair be kam kar raha ha?
1) Nahi ye zaroori nahi hai Foreign key banana. Aap Primary key ko doosre table ke kisi bhi coloumn se match kar sakte ho. 2) 2 se ziyada tables ko join karne ka tarika mein aage aane wale videos mein bataunga. 3) Alias ka use bina AS ke bhi kar sakte ho.
![[LIVE] : ONE ลุมพินี 86 | คู่เอก "คมเพชร vs ชาติพยัคฆ์"](http://i.ytimg.com/vi/m3q_dRYDuU8/mqdefault.jpg)
Sir aap ko jitna thanks kiya Jaye kam hai you are great sir really you are the best teacher ever I am third year student of BBA CA and I am doing my last year project in php such a greaaaat series I got to clear my all dauts and problems because I was in covid batch but now I have various strengths to do best sooooo really really thanks to yahoo baba I am really really thanks to you sir 🙏 🙏 🙏
Your most welcome :)
kafi acha smjhaya sir apne ye topic ....bilkul boring ni lgra...aur puri achi thra smjh aya
Thanks :)
Sir sach main aap bohot acche tarike se matlb kya batau yar aap bohot acche se padhate ho .. actually maine aapke php javascript and css ke saare dekh playlist dekh liye ...fir muze mysql main doubt tha , to socha aapke pass hoga uska bhi playlist and what ..sir u cant believe that .maine ek hi video se saara samjh main aa gya .. salute hain sir ji aapko ❤️❣️💗
Thanks and welcome :)
Thank you so much, bhai..
Till now I have watch so many videos of inner join but I don't understand anything but,you are the best for me becausee of your teaching method and your presentation is batter than others videos and people.
Thank you so much Again Brown 👍
Glad to hear that
Hats off to you sir for such a simple way of teaching. I was doing it last night for about 3 hrs but wasn't able to learn it because the instructor wasn't doing well. Nevertheless, thanks alot.
It's my pleasure
The way you teach is amazing sir..👍👍
THANK YOU SO MUCH
I AM FROM PAKISTAN
Fantastic. Exactly what I was looking for
Your most welcome :)
Thank you sir, videos contains all the information required to learn mysql and very nicely explained😊
You're most welcome
Very Nice explanation sir aj jakar samjh me aaya join . you are great sir . your all video are very good.
Thanks and welcome
6:17 It is interesting to note that alias names *p* and *c* are used in the SELECT command before assigning alias names in the FROM command.
SAME THING I HAVE NOTICED
So query is correct or incorrect
FROM COMMAND execute first and then where... At last SELECT executed
Love this channel
extremely easy to understand,
thank you 😃
You are welcome!
Fantastic. Exactly what I was looking for.
👍
Bhhot achaa samjhaya hai keep it up your good work ❤️❤️❤️❤️
Most Welcome :)
Thank you so much ❤
Nice explanation sir... Great content and easy way of teaching style....
Thanks sir
Thanks and welcome
Super sir ❤😊
Loved the way you explained Sir , thanks for it
Thanks and welcome
Sir I really really die hard thank to you for gave such a meaningful Lecture.. your teaching style is great great... जय श्रीराम
Your welcome ...Jai Shri Ram
nice explanation in every video of mysql,i have seen many
Thanks for liking
Thank u for this video..
Aapne python ke b video bnaye ho to link share kar de
Nahi abhi Python ka koi tutorial nahi banaya hai.
jordar bhai explantion
Finished watching
Nice video sir helping me for job
Sir i want to ask, rdbms and sql is my exam syllabus inme se kisko pehle study karu air jisse samajh me a jaye, u r best teacher sir anse teacher college me nahi hote.
Pehle SQL karo tab aapko RDBMS bhi samajh aajayega.
@@YahooBaba thanks sir for reply
Thanks Dear Sir
Most welcome
Perfect video,,I appreciate your help,
Glad it helped
it supper helpful................. brother
Nice.. conceptual
Happy Teachers Day Sir
Thanks Anshul :)
best of best thankyou
Your welcome :)
Thankyou sir so helpful for me❤️❤️❤️
Nice explain✅
You’re god thank you!
Superb Sir
GazakiAllah Sir G
NICE VIDEO ...........AWESOME
really good information
Glad you liked it
Thank you
nice sir
🙏
Very nice
thanku
Thank you, really helpful content!
Glad it was helpful!
Sir natural join theta join equi join ke function same hai ya thoda different pls cover kar dijiye
Yeh sab JOINs MySQL mein nahi hote.
Best video ever
Thanks Anmol :)
Sir, While entering data into personal table, how we'll be able to identify which state has which id? do we need to check manually in such case?
Varun we uses MySQl with any Programming language like PHP, Python to get the particular data. You can check this video what u r asking for : th-cam.com/video/S8M7V5mdSdI/w-d-xo.html
@@YahooBaba Thank You Sir 😊
well explained sir💜
amazing make a video to show three tables data by using a foreign key example: a student that has Id 3 and the class Id 4 means 5th class how to show Id 3 class name in PHP front end ??? hope you will response soon.
Video is coming soon regarding joining of three tables :)
Sir it's compulsory to use joins on the foreign key or primary key
Yes
Thank you Sir..
Most welcome
thanku sir🙂🙂🙂🙂🙂🙃🙃🙃🙃😊😊😊😊😊😋😋😋😋😋😋😇😇😇😇😇
superb sir
Thanks :)
thank u so much sir
Most welcome
Thank you very so much for this video sir :)
Most welcome!
Nice explanation as i expect👌👌
Thanks Satya :)
Bro, Laravel aur bootstrap padhna jaruri hai kya fresher ke liye. ..kab padhna chiye use.
Agar aap Web Designer banana chahte ho tabhi Bootstrap seekhna jaroori hai warna zaroori nahi hai. Agar aap PHP developer banana chahte ho toh Laravel seekh lijiye.
@@YahooBaba full stack developer banna thik hai ki kya kare sabse pehle. Job ke liye pehle kya padhe.
if we have to define inner join everytime after using foriegn key then can we say that foriegn key is only used for connecting tables nothing more..am i right?? correct me if i am wrong😄
Yes u r right.
thanks sir
Most welcome
bhaijan inner join is als working without any primary key and foreign key ,wat u say about it??
Foreign key toh compulsory nahi hai lekin Primary Key ke bina join nahi ho sakta.
Thanks
Waiting for more js videos
coming soon
@@YahooBaba are you know JAVA?
if you have two tables having empid ,name years of experience,
--monthly salary and --other table having attributes id and annual salary, then how can we find the emp who have
--expoerince >7 years and salary >1 lakh
After INNER JOIN you have to use WHERE CLAUSE and in Where clause use two conditions like table1.experience > 7 AND table2.salary > 100000
Plz launch your java course
the column selection commands are working fine without alias:
SELECT
id, name, percentage, age, gender, cityname
FROM
personal p
INNER JOIN
city c ON p.city = c.cid;
p and c are alias.
sir maine personal table main aik or column add krna ha grade ha kese ho sktaa ha?
Use the ALTER command for that. See the related in video in MySQL course playlist.
What is different between equal jion vs inner jion ??
What is jion ?
@@YahooBaba sorry spelling mistake Equal Join vs inner Join .?
explain this foreign key concept where how can i use this foreign key on already existing table
For that you have to use ALTER command. You can see that ALTER video in this same course playlist and read this article to ad Foreign key to already existing table : stackoverflow.com/questions/10028214/add-foreign-key-to-existing-table
Ap bhopal se ho kya?
No, I am from Ambala (Haryana)
@@YahooBaba nice videos🔥👍
A or B TABLE me se A ka
only uncomon data kasie fetch hoga??????? WITHOUT FETCHING THEIR COMMON DATA
Read this Article for that : stackoverflow.com/questions/1096478/how-to-fetch-unmatching-records-from-two-sql-tables
sir in my table when city name is repeated then the same name are show together and my id no are not in sequence if id no.1 and id no. 4 are having same city then 1 &4 are came together so sequence is 1,4,2,3,5,and so on plz tell me the right solution.
SO you have to use "Order By" city column.
@@YahooBaba sir is there any orther way that i can send you pictures of my data?
@@RahulYadav-qg7xi For what ?
To send pictures of data to show you what i want to ask
@@RahulYadav-qg7xi My email id : hello@yahoobaba.net
Can uh provide the pdf of mysql content
🙏🙏🙏it will be very helpful for me
You can get it from our website : www.yahoobaba.net
Sir, Are you know JAVA?
Yes I know Java
sir mene toh koi foreign key set nai ki fir bhi ye sab perfect work kar raha hai why ??
Foreign key is not necessary but Primary key is necessary that's why your SQL command is working fine.
Sir I used inner join but data not showing without error.
I can not tell anything without looking your SQL command and Table Structure. Paste ur SQL command here.
Why I'm getting only one row instead of getting whole row and column?
Paste ur SQL command here
Please give us data file for do practice
Sir pdf bhi provide karaiye
After doing inner join my city and cid columns are coming in ascending order . Help ?
Use (ORDER BY) clause to change the order.
@@YahooBaba okay thanks
Yupp correct I'm replying same 😊
yahi to smj nai ati k aliasing krne se phehle hi usko use kese kr skte hain system ko kese pata chalay k ye alias kis se relted hai baqi thoery tak thek hai
Muje ek parle biskut, ek samosa lakar do deu kaka or samosa bhaiya se
Aapko jis tarah pata chala same system ko bhi ese hi pata chalega
Pahele use kya lana he or baad men kaha se lana he, ese system kaam karegi
Sir I'm getting error code:3780 foreign key constraints incompatible
This error comes when Data type of Primary Key column and Foreign Key Column are different.
i face error 1005 error when apply foreign key plz help
good
I am getting this error when i run your code for personal table. Error Code: 1005. (errno: 150 "Foreign key constraint is incorrectly formed")
Check Your database structure cjeck you set in second table
❤
sir kb free hotey hn
how to zoom in sql workbench
zoom ?
@@YahooBaba zoom in the size of screen
Kitne video aur rah gye hai
10 videos rahte hain
@@YahooBaba Sir please *10 Days* nahi lana, *10 tutorial* k liya, *max* 4 to 5 Days ma finish karan Please?
1. Ya zaroori ha k hum sirf *Foreign key column* ko *Primary Key column* sa match karinga?
2. Hum 2 tables sa ziyada ka kis taran *Inner join* karinga?
3. Ap na *Aliases* karta wqt *AS* q nahi likha, os k bhagair be kam kar raha ha?
1) Nahi ye zaroori nahi hai Foreign key banana. Aap Primary key ko doosre table ke kisi bhi coloumn se match kar sakte ho.
2) 2 se ziyada tables ko join karne ka tarika mein aage aane wale videos mein bataunga.
3) Alias ka use bina AS ke bhi kar sakte ho.
@@YahooBaba 1. Mtlb ek *Primary key* ka hona zaroori ha?
Yes Primary Key is important because that's a unique identity.
@@YahooBaba Thank you Sir,
Abhe koe class ana wali ha?
आप table में data बहुत ज्यादा डालते हो तो उससे समझने में परेशानी होती है. डेटा थोडा कम लिजिया कररिये 😊😊
👍👍👍👍👍👍👍👍👍👍👍👍👌
😍😍
sir merey ps time bht thora ha
Hanji bataiye aapka kya Question hai ? My email id : hello@yahoobaba.net
Kuch samaj nahi aya ye wali video me
Mat dekho
Alies nhi aa li us
kindly sir jldi reply kr dey
Very nice
thanks
Thank you sir.
Thank you so much sir
Most welcome
Thanks
Welcome