openGauss每日一练第 1 天

CREATE TABLE products
(product_id integer,
product_name char(10),
category char(10)
) ;

INSERT INTO products (product_id, product_name, category) VALUES (1502,'olympus','electrncs');

INSERT INTO products VALUES (1502, 'olympus','electrncs');

INSERT INTO products (product_id, product_name, category) VALUES
(1502,'olympus', 'electrnc'),
(1601,'lamaze','toys'),
(1700,'wait', 'Books'),
(1666,'harry', 'toys');


select count(*) from products;
select * from products;
select product_name from products;

SELECT DISTINCT(product_name) from products;


select * from products order by product_id;

select * from products where product_name = 'olympus';

drop table products;

创建相关表值时注意类型长度。