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

语法如下:

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

我希望打印增加一行,怎么做,比如:

mysql> select '1' as `a`, '2' as `b`, '3' as `c`;
+---+---+---+
| a | b | c |
+---+---+---+
| 1 | 2 | 3 |
+---+---+---+
| 4 | 5 | 6 |
+---+---+---+
阅读 2.5k
1 个回答
select '1' as `a`, '2' as `b`, '3' as `c`
union all
select '4' as `a`, '5' as `b`, '6' as `c`
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题