数据仓库服务 GaussDB(DWS)-事务管理:LOCK

时间：2025-02-12 15:04:59

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;