数据仓库服务 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
推荐文章