MySQL UNION & UNION ALL Tutorial in Hindi / Urdu

In this tutorial you will learn mysql union and union all tutorial in Hindi, Urdu.You can learn how to show combine queries to two table with SQL UNION and UNION ALL 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

[@abdulwahabkhan1086]

Excellent. Very simple and good explaination. Appreciate it.

[@iqrashehzadi5590]

Sir i am from Pakistan .Dil khush Kr deya ap ke explanation ne Nice❤❤❤

[@almamunkhan6107]

thank you so much sir..

[@dhruvrajsinhjadeja-vfxarti3085]

Awesome sir :)

[@SunilYadav-ys8jd]

Thanks..Yahoo Baba

[@troubleshootingwarriors2739]

Fanatastic lecture bro 😀😀

[@arpitakar3384]

DOUBT
UNION when firstly explained has ram kumar with city delhi and agra ..
will show ram kumar twice if we ask for both name and city in select OR not

[@niftyboss534]

sir aap bahut acha sikhate batatae hain sir aap ne jitne sql commond bataye hain sir unko ek php par ek form bana kar usmain inser update delet reset aur data fetch in gried view ise kaise php form par karenge plz uspe video banayiye sir

[@litecode1641]

very good content. thanks 😍

[@YahooBaba]

Glad you liked it!

[@Lav-pw2yw]

Thank you bro

[@liladharmoharkar9226]

Thank you sir

[@nareshahirwar7406]

Very good Explanation Brother 👍

[@YahooBaba]

Thanks Naresh :)

[@AtifKhan-ok8mt]

Sir all lectures are very good to defined
but sir please start tutorials on django

[@jaiprakashchowdhary3198]

thnaks sir

[@abhishekanalysis490]

Awesome

[@Never_555]

Sir jab aap city dehli ke lecturers ko search kr rahe ho jinka cid 2 hai vo lecturers display hoge par lecturers table mai apne city column ko nhi course column ko explain kiya hai

[@Ritika123yte]

Thanku sir

[@hindi-english1664]

select a.name,a.age,b.cityname from student a inner join city b on a.city=b.cid WHERE b.cityname='delhi'
union all
select a.name,a.age,b.cityname from lecturers a inner join city b on a.city=b.cid WHERE b.cityname='delhi';
working :)
thank you baba

[@SonicTV]

hi , error in the union duration 1:06 (meera khan not exist in student table.)

[@samrokde]

Sir please DJango ki bhi ek playlist banaiyee

[@idreeskhan5129]

Thank you so much.

[@YahooBaba]

You're welcome!

[@nikitasinha8181]

thank u so much sir😄

[@YahooBaba]

Most welcome

[@subhenduprosadnath5542]

R/s,
Kindly clarify the city table where you taken. firstly you see us two table student and lectures but city is not showing,

[@syedumair9554]

awesome tuts

[@YahooBaba]

Thanks and welcome :)

[@CEKUNALGUPTA]

sir ji lecturer bhi toh ho sakta hai same name ka usme duplicasy kaise

[@subhenduprosadnath5542]

R/s,
I have tried, but sometimes it shows an error, with error code 1064, and sometimes runs okay.
When I execute the select name from the student; the comment then shows an error message.

[@shivamgupta3380]

At 10.54 it should be syntax error as not used ; at the end

[@chintanSharma29.02]

"If the system is able to tell the end of the statement without the semi-colon, omitting them does no harm. If the system gets confused, it matters. Since he has been able to leave them off, there isn't apparently a problem. A lot depends on how you're writing your SQL. If you're writing single statements in, say, PHP and then sending them to MySQL for processing, the semi-colon is optional."
-Copied from stack exchange
I think that the MySQL workbench identifies when there is only one statement to run and when there are multiple. In simple words, semicolon is only used to separate one statement from another

[@yuviyadav5666]

Nice bro 👏

[@YahooBaba]

Thanks for the visit

[@rabarhusen9170]

thank you 🌸
from kurdistan

[@YahooBaba]

You're welcome 😊

[@niftyboss534]

sir main stock markte main job karta hun prvt sir kuch data number save karne hote help mil jayegi sir

[@vakilsingh6078]

yes

[@sushilbhatt8352]

Bhi kutch important query bhi solve karwa do

[@arpitakar3384]

jannat hai toh yahi hjai

[@webtutorials947]

sir aap self employed ho yaa kahi par job karte ho

[@YahooBaba]

Self employed

[@amitkashyap6378]

Datatype same hona zaroori nahi h.

[@webtutorials947]

Sir Nodejs ke tutorial kab laa rahe ho

[@YahooBaba]

After July, 2020

[@creativestudio3343]

8:44

[@ApnaChanel11]

How Ram kumar is same enrty both students name is same but age us diffrent

[@webtutorials947]

Sir aapko kitna samay lagatha web development sikhne main

[@YahooBaba]

Mujhe 1 year Laga tha including web designing and PHP development.

[@webtutorials947]

sir mujhe bhi sikhna to aap mujhe tips dijiye naa ki 1 din kitne gante time dena chaiye

[@indalsingh6675]

Agar 2nd table me column ka name alag huaa to kyo kaam karega

[@ApnaChanel11]

data type same honi chaiye name doesnt matter do it on practce

[@harshgupta8192]

bhai semicolon kha h?

[@mahimapatidarpatidar9926]

Apke Charan kha h Prabhu 🙏

[@TNT.ESPORT]

Sir aapka what'sapp no mil Shakta hai hai

[@YahooBaba]

No dear I don't share whatsapp no. , So you can send any message to our facebook account or email at : [e-mail]

[@ashrafjamal7178]

Thanks sir

[@YahooBaba]

Your Welcome