MySQL UNION & UNION ALL Tutorial in Hindi / Urdu

[@abdulwahabkhan1086]

Excellent. Very simple and good explaination. Appreciate it.

[@iqrashehzadi5590]

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

[@troubleshootingwarriors2739]

Fanatastic lecture bro 😀😀

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

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

[@dhruvrajsinhjadeja-vfxarti3085]

Awesome sir :)

[@almamunkhan6107]

thank you so much sir..

[@nareshahirwar7406]

Very good Explanation Brother 👍

[@YahooBaba]

Thanks Naresh :)

[@litecode1641]

very good content. thanks 😍

[@YahooBaba]

Glad you liked it!

[@liladharmoharkar9226]

Thank you sir

[@AtifKhan-ok8mt]

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

[@nikitasinha8181]

thank u so much sir😄

[@YahooBaba]

Most welcome

[@idreeskhan5129]

Thank you so much.

[@YahooBaba]

You're welcome!

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

[@SunilYadav-ys8jd]

Thanks..Yahoo Baba

[@rabarhusen01]

thank you 🌸 from kurdistan

[@YahooBaba]

You're welcome 😊

[@Lav-pw2yw]

Thank you bro

[@abhishekanalysis490]

Awesome

[@yuviyadav5666]

Nice bro 👏

[@YahooBaba]

Thanks for the visit

[@SonicTV]

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

[@syedumair9554]

awesome tuts

[@YahooBaba]

Thanks and welcome :)

[@ashrafjamal7178]

Thanks sir

[@YahooBaba]

Your Welcome

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

[@jaiprakashchowdhary3198]

thnaks sir

[@samrokde]

Sir please DJango ki bhi ek playlist banaiyee

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

[@Ritika123yte]

Thanku sir

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

[@niftyboss534]

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

[@vakilsingh6078]

yes

[@webtutorials947]

sir aap self employed ho yaa kahi par job karte ho

[@YahooBaba]

Self employed

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

[@sushilbhatt8352]

Bhi kutch important query bhi solve karwa do

[@creativestudio3343]

8:44

[@indalsingh6675]

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

[@ZahidkhanDiary]

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

[@webtutorials947]

Sir Nodejs ke tutorial kab laa rahe ho

[@YahooBaba]

After July, 2020

[@amitkashyap6378]

Datatype same hona zaroori nahi h.

[@ZahidkhanDiary]

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

[@harshgupta8192]

bhai semicolon kha h?

[@arpitakar3384]

jannat hai toh yahi hjai

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