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.

[sargata]

Simple and easy to understand. Thanks!

[nicolewynne]

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!!!

[rajashekar]

Professional and clear explanation thank you

[whoissuhail]

same no. of columns having same datatype ?

[suryateja]

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