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;