+------+---------+---------------------+
2 rows in set
gbase> SELECT sno,sdate FROM t_student UNION SELECT sno,sdate
FROM t_result;
+------+---------------------+
| sno
| sdate
|
+------+---------------------+
|
1 | 2013-10-14 17:56:19 |
|
2 | 2013-10-14 17:56:19 |
|
1 | 2013-10-14 17:57:15 |
|
2 | 2013-10-14 17:57:15 |
+------+---------------------+
4 rows in set
示例6:CHAR 和CHAR 类型的UNION。
gbase> USE test;
Query OK, 0 rows affected
gbase> CREATE TABLE t1(a char(10));
Query OK, 0 rows affected
gbase> CREATE TABLE t2(a char(255));
Query OK, 0 rows affected
gbase> CREATE TABLE ta AS SELECT * FROM t1 UNION SELECT *
FROM t2;
Query OK, 0 rows affected
gbase> DESC ta;
+-------+--------------+------+-----+---------+-------+
| Field | Type
| Null | Key | Default | Extra |
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
1098
+-------+--------------+------+-----+---------+-------+
| a
| varchar(255) | YES
|
| NULL
|
|
+-------+--------------+------+-----+---------+-------+
1 row in set