MySQL SubQuery with EXISTS & NOT EXISTS Tutorial in Hindi / Urdu
Вставка
- Опубліковано 27 лис 2019
- In this tutorial you will learn mysql subquery with exists or not exists tutorial in Hindi, Urdu.You can learn how to make a mysql nested select query and how to use sql exists or not exists clause 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
Nice video I got clear overview regarding subqueries
thanks you sir, after learning basics from you i can learn more by my self....
AND...
this way you can fetch more results....
select s_id as "Roll no", name as Student from student
where
exists(select c_id from course where c_name in ("Btech","BBA")) and
c_id in (select c_id from course where c_name in ("Btech","BBA"))
order by Student;
i love how you explains
Awesome sir :)
Nice explanation.
thank you sir jee
best channel
Thanks sir, for teaching ...
Most welcome
Wonderful
SUPERB EXPLANATION SIR, KEEP IT UP, PLEASE DO BRING MORE AND MORE SUCH USEFULL VIDEOS. IF POSSIBLE DO VIDEOS ON MATHEMATICS.
Finished watching
SooperB Sir Ji
Thanks :)
Really great Explanation sir.. I love your all vedio explanation. ❤️❤️ ♟️sir.
Thanks and welcome :)
yahoo baba please ek video corelated subquery pe bhi bana dijiye kaafi confusing topic hai.
Thank u...
Welcome 😊
best
Baba ji aap bhout aacha pdhate ho thanks but please Please and PLEASE NESTED SUBQUERY WITH MULTIPLE COLUMNS KE UPAR VIDEO BNA DI JALDI SE AND CORRELATED QUERY KE UPAR BHI WITH RULES AND SYNTAX LIKE YOU ALWAYS DO....PLEASEEEEEEE
Nahi bana Google pe dekh lo
What is the use of SubQuery in Real world Projects ?
Very Helpful video Bhai
but jese aapne Sub query ko where clause me Filter kiya kya humne use show kar skte hai,name ki side me
Yes u can.
sir if i use this SELECT * FROM personal JOIN courses ON personal.courses = courses.cid WHERE cid = "MBA"; ??????????
Wqiting for python tutorials
Same result is coming with joins then what is the difference? is there any difference of speed in running query by sql server? It is necessary to know for future usage.
Using Join first u have to join both tables then u have to apply commands as Select..., But this query helps in reducing command and codes thus saving data and time and efficiency
sir trigger par video banao na
I think this advance of MYSQL
7:28
Exists / Not Exists
Hello sir how can we allow user to create table with their own name in php
Why you want to allow user to create Table ? I don't think their is any need.
@@YahooBaba sir just asking because if it is possible then I can run my idea very smoothly plss if it is possible tell me
Sir the error message has been displayed saying that "Subquery returns more than 1 row" when I apply "IN". How to resolve?
this way you can do...
select s_id as "Roll no", name as Student from student
where
exists(select c_id from course where c_name in ("Btech","BBA")) and
c_id in (select c_id from course where c_name in ("Btech","BBA"))
order by Student;
I am getting the error sir
it's showing an unknown column 'course' in where clause
i rechecked everything
do we have to join the tables ?
no you must be writing wrong query, you dont need to join tables to sub query.
How many videos remain in this series? ☺
In MySQL 5 videos are remaining and and in PHP roundabout 50 videos are remaining.
@@YahooBaba thanks
When project with pho mysql will be start?
After completion of MySQL course I will start PHP with MySQL project.
@@YahooBaba sir, are you cover ajax with PHP with MySQL?
ye sab command api me work karegi?
Dear yeh commands MySQL ki commands hai na ki API ki.
@@YahooBaba Thankyou sir for explaination
@@YahooBaba to phir sir ye real time me kaha use hoti ye command
khana bnane ata h?
I am getting an error 1242
How to solve please tell me