文档首页/ 数据仓库服务 GaussDB(DWS)/ 工具指南/ DSC/ Teradata语法迁移/ 数据操作语句（DML）/ UPDATE
更新时间：2024-06-29 GMT+08:00
查看PDF
分享

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;