Documentation Home
MySQL 9.2 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.5Mb
PDF (A4) - 40.6Mb
Man Pages (TGZ) - 259.6Kb
Man Pages (Zip) - 366.8Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


15.2.18 UNION Clause

Press CTRL+C to copy
query_expression_body UNION [ALL | DISTINCT] query_block [UNION [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14,Set Operations with UNION, INTERSECT, and EXCEPT

UNION combines the result from multiple query blocks into a single result set. This example uses SELECT statements:

Press CTRL+C to copy
mysql> SELECT 1, 2; +---+---+ | 1 | 2 | +---+---+ | 1 | 2 | +---+---+ mysql> SELECT 'a', 'b'; +---+---+ | a | b | +---+---+ | a | b | +---+---+ mysql> SELECT 1, 2 UNION SELECT 'a', 'b'; +---+---+ | 1 | 2 | +---+---+ | 1 | 2 | | a | b | +---+---+