MySQL 自創欄位

也是之前面試回家才想到犯的錯誤

SELECT DNAME, '1st table' AS 'Table名' FROM DEPARTMENT
UNION
SELECT DNAME, '2nd table' AS 'Table名' FROM DEPARTMENT;

同一張表都多出來一個欄位，但欄位名稱不一樣
因為是字串，故記得加單引號