ABORT

    作用等同于，早期SQL有用ABORT，现在推荐使用ROLLBACK。

    注意事项

    参数说明

    WORK | TRANSACTION

    2. openGauss=# CREATE TABLE customer_demographics_t1
    3. (
    4.     CD_DEMO_SK                INTEGER               NOT NULL,
    5.     CD_GENDER                 CHAR(1)                       ,
    6.     CD_MARITAL_STATUS         CHAR(1)                       ,
    7.     CD_EDUCATION_STATUS       CHAR(20)                      ,
    8.     CD_CREDIT_RATING          CHAR(10)                      ,
    9.     CD_DEP_COUNT              INTEGER                       ,
    10.     CD_DEP_EMPLOYED_COUNT     INTEGER                       ,
    11.     CD_DEP_COLLEGE_COUNT      INTEGER
    13. WITH (ORIENTATION = COLUMN,COMPRESSION=MIDDLE)
    14. ;
    16. --插入记录。
    17. openGauss=# INSERT INTO customer_demographics_t1 VALUES(1920801,'M', 'U', 'DOCTOR DEGREE', 200, 'GOOD', 1, 0,0);
    19. --开启事务。
    20. openGauss=# START TRANSACTION;
    21. --更新字段值。
    22. openGauss=# UPDATE customer_demographics_t1 SET cd_education_status= 'Unknown';
    24. --终止事务，上面所执行的更新会被撤销掉。
    25. openGauss=# ABORT; 
    27. --查询数据。
    28. openGauss=# SELECT * FROM customer_demographics_t1 WHERE cd_demo_sk = 1920801;
    29. cd_demo_sk | cd_gender | cd_marital_status | cd_education_status  | cd_purchase_estimate | cd_credit_rating | cd_dep_count | cd_dep_employed_count | cd_dep_college_count 
    30. ------------+-----------+-------------------+----------------------+----------------------+------------------+--------------+-----------------------+----------------------
    31.     1920801 | M         | U                 | DOCTOR DEGREE        |                  200 | GOOD             |            1 |                     0 |                    0
    32. (1 row)

    相关链接

    SET TRANSACTION，，ROLLBACK