数据仓库服务 GAUSSDB(DWS)-LOCK

时间：2024-06-29 17:51:37

数据仓库服务 GAUSSDB(DWS) 事务管理

LOCK

DSC工具在迁移MySQL 事务处理锁表语句时会根据 GaussDB (DWS)特性进行相应适配。

输入示例

     
          ## A.
START TRANSACTION;
LOCK TABLES `mt`.`runoob_tbl` WRITE,`mt`.`runoob_tb2` READ;
commit;

## B.
START TRANSACTION;
LOCK TABLES `mt`.`runoob_tbl` WRITE;
commit;

## C.
START TRANSACTION;
LOCK TABLES `mt`.`runoob_tbl` READ,`mt`.`runoob_tbl` AS t1 READ;
commit;

输出示例

     
          -- A.
START TRANSACTION;
LOCK TABLE "mt"."runoob_tbl" IN AC CES S EXCLUSIVE MODE;
LOCK TABLE "mt"."runoob_tb2" IN ACCESS SHARE MODE;
COMMIT WORK;

-- B.
START TRANSACTION;
LOCK TABLE "mt"."runoob_tbl" IN ACCESS EXCLUSIVE MODE;
COMMIT WORK;

-- C.
START TRANSACTION;
LOCK TABLE "mt"."runoob_tbl" IN ACCESS SHARE MODE;
COMMIT WORK;