如何在不从现有表中选择的情况下生成包含2行和2列的表？我正在寻找的是一个返回的select语句,
例如
id | value --------- 1 | 103 2 | 556
id | value
---------
1 | 103
2 | 556
UNION
SELECT 1 as id,103 as valueUNIONSELECT 2 as id,556 as value
SELECT 1 as id,103 as value
SELECT 2 as id,556 as value
See this SQLFiddle
