mysql UNION 语法具体阐明[网站编程]

本文介绍如安在mysql中利用union来组合成一个单一的后果

union语法

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

下面看一款查询三个表普通办法

select brand from car;
select brand from computer;
select brand from clothing;

我们操纵union衔接起来查询

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;