mysql UNION 文法詳細說明與執行個體教程

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;