mysql使用dual进行自定义数据查询

 使用dual生成一列数据（基本无用）

mysql>  SELECT 'name','a','b','c' from dual;
+------+---+---+---+
| name | a | b | c |
+------+---+---+---+
| name | a | b | c |
+------+---+---+---+
1 row in set (0.01 sec)

使用dual和union将自定义数据生成虚拟表

mysql>  SELECT 'a' as 'NAME'  from dual
 union SELECT 'b'  from dual;
+------+
| NAME |
+------+
| a    |
| b    |
+------+
2 rows in set (0.01 sec)

多列数据

mysql> SELECT 'zhangsan' AS 'NAME', 1 AS 'id' FROM DUAL UNION
SELECT 'lisi', 2 FROM DUAL;
+----------+----+
| NAME     | id |
+----------+----+
| zhangsan |  1 |
| lisi     |  2 |
+----------+----+
2 rows in set (0.02 sec)

to be continue