更新时间:2024-12-10 GMT+08:00
UPDATE
DSC支持和迁移UPDATE语句(缩写关键字为UPD)。
输入:UPDATE,使用TABLE ALIAS
1 2 3 4 5 |
UPDATE T1 FROM tab1 T1, tab2 T2 SET c1 = T2.c1 , c2 = T2.c2 WHERE T1.c3 = T2.c3; |
输出
1 2 3 4 5 |
UPDATE tab1 T1 SET c1 = T2.c1 , c2 = T2.c2 FROM tab2 T2 WHERE T1.c3 = T2.c3; |
输入:UPDATE,使用TABLE ALIAS和子查询
1 2 3 4 5 |
UPDATE t1 FROM tab1 t1, ( SELECT c1, c2 FROM tab2 WHERE c2 > 100 ) t2 SET c1 = t2.c1 WHERE t1.c2 = t2.c2; |
输出
1 2 3 4 5 |
UPDATE tab1 t1 SET c1 = t2.c1 FROM ( SELECT c1, c2 FROM tab2 WHERE c2 > 100 ) t2 WHERE t1.c2 = t2.c2; |
输入:UPDATE,使用ANALYZE
1 2 3 |
UPD employee SET ename = 'Jane' WHERE ename = 'John'; COLLECT STAT on employee; |
输出
1 2 3 |
UPDATE employee SET ename = 'Jane' WHERE ename = 'John'; ANALYZE employee; |
父主题: 数据操作语句(DML)