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

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);