MySQL UNIONS are easy

#MySQL #tutorial #course
Union tutorial example explained
-- NO DUPLICATES
SELECT first_name, last_name FROM employees
UNION
SELECT first_name, last_name FROM customers;
-- DUPLICATES OK
SELECT first_name, last_name FROM employees
UNION ALL
SELECT first_name, last_name FROM customers;

[@BroCodez]

-- NO DUPLICATES
SELECT first_name, last_name FROM employees
UNION
SELECT first_name, last_name FROM customers;
-- DUPLICATES OK
SELECT first_name, last_name FROM employees
UNION ALL
SELECT first_name, last_name FROM customers;

[@markodarth]

I just wanted to say that sir are the greatest teacher about the matter you are teaching in the whole of internet. Thank you for doing what you are doing. Your videos have helped me a lot.

[@sargata3054]

Simple and easy to understand. Thanks!

[@nicolewynne4781]

Please could you do PHP full course? Your videos are like an oasis in the desert for people like us who have financial struggles. Thanks a million BRO!!!

[@kristijanlazarev]

He already has one

[@sajadtorkamani9399]

Very good explanation - thanks :)

[@rajashekar4991]

Professional and clear explanation thank you

[@jabendi4573]

BRO, you DA best !

[@sandrafitri4973]

Great tuorial

[@Imariml]

Thank you, you really simplify it :)

[@Worldsbestdad505]

Sick video brah

[@xKawaiNekox]

thank you, it is really helpful

[@gustavoaguilara.9873]

I love this video! ❤

[@kristijanlazarev]

GODLIKEEE!!!

[@kennymccormick9103]

Thank you very much!

[@whoissuhail]

same no. of columns having same datatype ?

[@suryateja6828]

can we create performed union as new table with a name?

[@IMHEMOX]

I needed this thanks bro🤍