云数据库 GaussDB-START TRANSACTION:示例

时间：2023-11-01 16:22:03

云数据库 GaussDB

示例

--以默认方式启动事务。openGauss=# START TRANSACTION;openGauss=# SELECT * FROM tpcds.reason;openGauss=# END;--以默认方式启动事务。openGauss=# BEGIN;openGauss=# SELECT * FROM tpcds.reason;openGauss=# END;--以隔离级别为READ COMMITTED，读/写方式启动事务。openGauss=# START TRANSACTION ISOLATION LEVEL READ COMMITTED READ WRITE;openGauss=# SELECT * FROM tpcds.reason;openGauss=# COMMIT;