《Mysql入門詳解MySQL中UNION的用法》要點：
本文介紹了Mysql入門詳解MySQL中UNION的用法，希望對您有用。如果有疑問，可以聯系我們。
如果想選擇其他幾個表中的行或從一個單一的表作為一個單獨的成果集行的幾個集會,那么可以使用的UNION.MYSQL學習
UNION在MySQL4.0以上版本能力可以使用.本節說明如何使用它.MYSQL學習
假設有兩個表,潛在和實際的客戶列表,供應商購買耗材合并所有三個表中的姓名和地址,來創建一個單一的郵件列表.UNION提供了一種辦法做到這一點.假設三個表有以下內容：MYSQL學習
mysql> SELECT * FROM prospect; +---------+-------+------------------------+ | fname | lname | addr | +---------+-------+------------------------+ | Peter | Jones | 482 Rush St., Apt. 402 | | Bernice | Smith | 916 Maple Dr. | +---------+-------+------------------------+ mysql> SELECT * FROM customer; +-----------+------------+---------------------+ | last_name | first_name | address | +-----------+------------+---------------------+ | Peterson | Grace | 16055 Seminole Ave. | | Smith | Bernice | 916 Maple Dr. | | Brown | Walter | 8602 1st St. | +-----------+------------+---------------------+ mysql> SELECT * FROM vendor; +-------------------+---------------------+ | company | street | +-------------------+---------------------+ | ReddyParts, Inc. | 38 Industrial Blvd. | | Parts-to-go, Ltd. | 213B Commerce Park. | +-------------------+---------------------+
這不要緊,如果所有的三個表具有分歧的列名.下面的查詢演示了如何選擇一下子從三個表的名稱和地址：MYSQL學習
mysql> SELECT fname, lname, addr FROM prospect -> UNION -> SELECT first_name, last_name, address FROM customer -> UNION -> SELECT company, '', street FROM vendor; +-------------------+----------+------------------------+ | fname | lname | addr | +-------------------+----------+------------------------+ | Peter | Jones | 482 Rush St., Apt. 402 | | Bernice | Smith | 916 Maple Dr. | | Grace | Peterson | 16055 Seminole Ave. | | Walter | Brown | 8602 1st St. | | ReddyParts, Inc. | | 38 Industrial Blvd. | | Parts-to-go, Ltd. | | 213B Commerce Park. | +-------------------+----------+------------------------+
如果想選擇所有記錄,包含重復的,請ALL的第一個UNION關鍵字：MYSQL學習
mysql> SELECT fname, lname, addr FROM prospect -> UNION ALL -> SELECT first_name, last_name, address FROM customer -> UNION -> SELECT company, '', street FROM vendor; +-------------------+----------+------------------------+ | fname | lname | addr | +-------------------+----------+------------------------+ | Peter | Jones | 482 Rush St., Apt. 402 | | Bernice | Smith | 916 Maple Dr. | | Grace | Peterson | 16055 Seminole Ave. | | Bernice | Smith | 916 Maple Dr. | | Walter | Brown | 8602 1st St. | | ReddyParts, Inc. | | 38 Industrial Blvd. | | Parts-to-go, Ltd. | | 213B Co妹妹erce Park. | +-------------------+----------+------------------------+
歡迎參與《Mysql入門詳解MySQL中UNION的用法》討論，分享您的想法，維易PHP學院為您提供專業教程。
