mysql - 如何使用别名显示天和月而不出现错误 - mysql

Question

我正在尝试与工会一起取消工资。但后来我在下面的代码中出现错误:

(SELECT 1 AS id, a+b AS 'days', 2 AS id2, c+e AS 'months' FROM
((SELECT 0 a UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7
UNION SELECT 8 UNION SELECT 9) a, (SELECT 0 b UNION SELECT 10 UNION SELECT 20 UNION SELECT 30) d, 
 (SELECT 2 AS id2, c+e AS 'months' FROM (SELECT 0 c UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) c, 
(SELECT 0 e UNION SELECT 10) m)

就像:#1248 - 每个派生表必须有自己的别名

我可以在这段代码中做什么或更改什么？感谢您的帮助。

Answer 1

您的查询中有一些错误。我想这可能就是您正在寻找的:

SELECT 1 AS id, a+b AS 'days', 2 AS id2, months
FROM ((SELECT 0 a UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7
UNION SELECT 8 UNION SELECT 9) a, 
      (SELECT 0 b UNION SELECT 10 UNION SELECT 20 UNION SELECT 30) d, 
      (SELECT 2 AS id2, c+e AS 'months' 
       FROM (SELECT 0 c UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) c, 
             (SELECT 0 e UNION SELECT 10) m
            ) x
      )

Demo on dbfiddle