数据仓库服务 GAUSSDB(DWS)-START TRANSACTION:示例

时间:2024-01-26 16:15:25

示例

  • 以默认方式启动事务:
    1
    2
    3
    START TRANSACTION;
    SELECT * FROM tpcds.reason;
    END;
    
  • 以隔离级别为READ COMMITTED,读/写方式启动事务:
    1
    2
    3
    START TRANSACTION ISOLATION LEVEL READ COMMITTED READ WRITE;
    SELECT * FROM tpcds.reason;
    COMMIT;
    
support.huaweicloud.com/sqlreference-820-dws/dws_06_0265.html