mysql - 连接 SELECT * 结果

Question

如何连接 SELECT * 查询的结果？

我可以使用它来选择全部，然后创建一个附加的串联属性，但我不知道如何单独串联返回的属性。

SELECT *, CONCAT(Cust_FName, ' ', Cust_LName) AS Cust_Name
FROM Customer_Information AS Customers

产品:

Cust_ID, Cust_FName, Cust_LName, Cust_Name

但我想使用 SELECT all 并获取:

Cust_ID, Cust_Name

Answer 1

如果您想要的输出是

Cust_ID, Cust_Name

那么以下应该可以工作

SELECT Cust_ID, CONCAT(Cust_FName, ' ', Cust_LName) AS Cust_Name
FROM Customer_Information AS Customers;

编辑:

有趣的嵌套 SELECT

SELECT Cust_ID, CONCAT(Cust_FName, ' ', Cust_LName) AS Cust_Name
FROM (SELECT * FROM Customer_Information AS Customers);