云数据库 GaussDB-COMMIT | END:示例

时间：2025-02-12 15:07:58

云数据库 GaussDB

示例

  
       --创建SCHEMA。gaussdb=# CREATE SCHEMA tpcds;--创建表。gaussdb=# CREATE TABLE tpcds.customer_demographics_t2(    CD_DEMO_SK                INTEGER               NOT NULL,    CD_GENDER                 CHAR(1)                       ,    CD_MARITAL_STATUS         CHAR(1)                       ,    CD_EDUCATION_STATUS       CHAR(20)                      ,    CD_PURCHASE_ESTIMATE      INTEGER                       ,    CD_CREDIT_RATING          CHAR(10)                      ,    CD_DEP_COUNT              INTEGER                       ,    CD_DEP_EMPLOYED_COUNT     INTEGER                       ,    CD_DEP_COLLEGE_COUNT      INTEGER)DISTRIBUTE BY HASH (CD_DEMO_SK);--开启事务。   gaussdb=# START TRANSACTION;--插入数据。gaussdb=# INSERT INTO tpcds.customer_demographics_t2 VALUES(1,'M', 'U', 'DOCTOR DEGREE', 1200, 'GOOD', 1, 0, 0);gaussdb=# INSERT INTO tpcds.customer_demographics_t2 VALUES(2,'F', 'U', 'MASTER DEGREE', 300, 'BAD', 1, 0, 0);--提交事务，让所有更改永久化。gaussdb=# COMMIT;--查询数据。gaussdb=# SELECT * FROM tpcds.customer_demographics_t2;--删除表tpcds.customer_demographics_t2。gaussdb=# DROP TABLE tpcds.customer_demographics_t2;--删除SCHEMA。gaussdb=# DROP SCHEMA tpcds;