dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Understanding UNION in MySQL

Learn how to identify unique records in MySQL.


advertisement

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


Assuming there are tables EMP and EMP2, which have the same schema, and there are possible duplicate IDs present in them — the following query will help us identify the unique records:

Schema:

CREATE TABLE EMP (NAME VARCHAR(30), ID INT(5))
CREATE TABLE EMP2 (NAME VARCHAR(30), ID INT(5))

Query:

SELECT ID FROM EMP UNION SELECT ID FROM EMP2;

 

Visit the DevX Tip Bank

 





   
Sridhar M S. is a Java developer from Bangalore, India. He holds a master's degree in Computer Science.
Thanks for your registration, follow us on our social networks to keep up-to-date