MySQL Union

最新推荐文章于 2022-11-15 15:56:22 发布

minglotus

最新推荐文章于 2022-11-15 15:56:22 发布

阅读量358

点赞数

分类专栏： database 文章标签： sql union

本文链接：https://blog.csdn.net/minglotus/article/details/45922095

版权

database 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

Syntax:

    select column1 [, column2] from table1[,table2] [where condition]

    union

    select column3 [, column4] from table3[,table4] [where condition]

Usage Prerequisite:

    each table must have the same number of columns, same number of column expressions,  the same data type and have them the same order

Union all: contains duplicate rows

Column names: the column names from the first select clause is the default column names for the result row set

Order by or limit clause should be enclosed with brackets for sub-select clause, btw, the use of order by in a sub select does not guarantee the order of final union set, since union itself is orderless.

Thus, if order by is used without limit in a select clause, it is generally optimized since it does not have any effect in the final result.

This kind of order by cannot reference column names by table-name.column-name, but use alias in the first select clause