openGauss学习笔记32 openGauss 高级数据管理批处理模式

数据运维 2023-09-26 宇宙之一粟手机阅读

CREATE TABLE customer
(
c_customer_sk integer,
c_customer_id char(5),
c_first_name char(6),
c_last_name char(8),
Amount integer
);

INSERT INTO customer(c_customer_sk, c_customer_id, c_first_name,Amount) VALUES (3769, 'hello', 'Grace', 1000);
INSERT INTO customer (c_customer_sk, c_first_name) VALUES (3769, 'Grace');
INSERT INTO customer (c_customer_sk, c_customer_id, c_first_name) VALUES (3769, 'hello', DEFAULT);
INSERT INTO customer (c_customer_sk, c_customer_id, c_first_name,Amount) VALUES
(6885, 'maps', 'Joes',2200),
(4321, 'tpcds', 'Lily',3000),
(9527, 'world', 'James',5000);