Mysql UNION syntax and example

Mysql tutorial union syntax and example tutorial

This article describes how to use union in mysql to combine a single result.

Union syntax

Select field1, field2... union [all | distinct] select field1, field2...

The following describes a common method for querying three tables.

Select brand from car;
Select brand from computer;
Select brand from clothing;

We use union to join and query

Select brand from car union select brand from computer union select brand from clothing;

Select brand from car union all select brand from computer union allselect brand from clothing;