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

时间:2025-02-12 15:05:09

示例

  • 以默认方式启动事务:
    1234
    START TRANSACTION;CREATE TABLE IF NOT EXISTS table1 (a int,b int);SELECT * FROM table1;END;
  • 以隔离级别为READ COMMITTED,读/写方式启动事务:
    1234
    START TRANSACTION ISOLATION LEVEL READ COMMITTED READ WRITE;CREATE TABLE IF NOT EXISTS table1 (a int,b int);SELECT * FROM table1;COMMIT;
support.huaweicloud.com/sqlreference-dws/dws_06_0265.html