Home  >  Article  >  Database  >  mysql的uion跟union all的区别

mysql的uion跟union all的区别

WBOY
WBOYOriginal
2016-06-07 16:26:442044browse

mysql的uion和union all的区别 uion和union all的主要区别是union all是把结果集直接合并在一起,而是将union 是把union all后的结果进行一次distinct,去除重复记录后的结果。

mysql的uion和union all的区别
uion和union all的主要区别是union all是把结果集直接合并在一起,而是将union 是把union all后的结果进行一次distinct,去除重复记录后的结果。
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:MySQL触发器的创设Next article:地图reduce 与mysql 交互