请教一则简单的SQL查询问题

李惟

语法如下：

1. mysql> select '1' as `a`, '2' as `b`, '3' as `c`;
   
2. +---+---+---+
   
3. | a | b | c |
   
4. +---+---+---+
   
5. | 1 | 2 | 3 |
   
6. +---+---+---+
   
7. 1 row in set (0.00 sec)

复制代码

我希望打印增加一行，怎么做，比如：

1. +---+---+---+
   
2. | a | b | c |
   
3. +---+---+---+
   
4. | 1 | 2 | 3 |
   
5. +---+---+---+
   
6. | 4 | 5 | 6 |
   
7. +---+---+---+

复制代码

李惟

找到方法了

1. select '1' as `a`, '2' as `b`, '3' as `c`
   
2. union all
   
3. select '4' as `a`, '5' as `b`, '6' as `c`

复制代码

action08

    select '1' as `a`, '2' as `b`, '3' as `c`
    union all
    select '4' as `a`, '5' as `b`, '6' as `c`

三行属于一段代码么？？

action08

1. mysql> use test;
   
2. Database changed
   
3. mysql>
   
4. mysql>     select '1' as `a`, '2' as `b`, '3' as `c`
   
5.     ->     union all
   
6.     ->     select '4' as `a`, '5' as `b`, '6' as `c`
   
7.     -> ;
   
8. +---+---+---+
   
9. | a | b | c |
   
10. +---+---+---+
    
11. | 1 | 2 | 3 |
    
12. | 4 | 5 | 6 |
    
13. +---+---+---+
    
14. 2 rows in set (0.00 sec)
    
15. 
    
16. mysql>
    
17. mysql>
    

复制代码

感觉不太常用啊，

action08

1. mysql>
   
2. mysql> select '1' as `a`, '2' as `b`, '3' as `c`     union all     select '4' as `a`, '5' as `b`, '6' as `c` union all select '7' as  'a','8' as 'b' ,'9' as 'c'  ;
   
3. +---+---+---+
   
4. | a | b | c |
   
5. +---+---+---+
   
6. | 1 | 2 | 3 |
   
7. | 4 | 5 | 6 |
   
8. | 7 | 8 | 9 |
   
9. +---+---+---+
   
10. 3 rows in set (0.00 sec)
    
11. 
    
12. mysql>
    
13. mysql>
    

复制代码

李惟

回复 4# action08


     导出测试的csv数据