数据仓库服务 GaussDB(DWS)-INSERT:示例

时间：2025-02-12 15:01:49

示例

创建表reason_t1：

   
        -- 创建表reason_t1。CREATE TABLE reason_t1(    TABLE_SK          INTEGER               ,    TABLE_ID          VARCHAR(20)           ,    TABLE_NA          VARCHAR(20))WITH(ORIENTATION=COLUMN, ENABLE_HSTORE=ON);

向表中插入一条记录：

   
        INSERT INTO reason_t1(TABLE_SK, TABLE_ID, TABLE_NA) VALUES (1, 'S01', 'StudentA');

向表中插入多条记录：

   
        INSERT INTO reason_t1 VALUES (1, 'S01', 'StudentA'),(2, 'T01', 'TeacherA'),(3, 'T02', 'TeacherB');SELECT * FROM reason_t1 ORDER BY 1; TABLE_SK | TABLE_ID | TABLE_NAME----------+----------+------------        1 |      S01 |   StudentA        2 |      T01 |   TeacherA        3 |      T02 |   TeacherB(3 rows)