2 |
+---------------------+------------+--------+
10 rows in set
gbase> UPDATE t2 SET b=89.3 where c <1000;
Query OK, 5 rows affected
Rows matched: 5
Changed: 5
Warnings: 0
-- 查看没有被更新的数据行对应的TIMESTAMP 列,TIMESTAMP 列的值保
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
1060
持不变。
gbase> SELECT * FROM t2 WHERE c <1000;
+---------------------+---------+------+
| a
| b
| c
|
+---------------------+---------+------+
| 2013-12-17 14:17:57 | 89.3000 |
11 |
| 2013-12-17 14:17:57 | 89.3000 |
111 |
| 2013-12-17 14:17:57 | 89.3000 |
123 |
| 2013-12-17 14:17:57 | 89.3000 |
1 |
| 2013-12-17 14:17:57 | 89.3000 |
2 |
+---------------------+---------+------+
5 rows in set
-- 查看没有被更新的数据行对应的TIMESTAMP 列,TIMESTAMP 列的值保
持不变。
gbase> SELECT * FROM t2 WHERE c >=1000;
+---------------------+-----------+--------+
| a
| b
| c
|
+---------------------+-----------+--------+
| 2013-12-17 14:11:16 | 1334.5600 |
1111 |
| 2013-12-17 14:11:16 |