openGauss每日一练第2天 | openGauss查询、更新和删除基本使用

-- 1.
create table products (product_id integer, product_name char(30), category char(20));

-- 2.
insert into products values(1502, 'olympus camera', 'electrncs');
insert into products values
(1601, 'lamaze', 'toys'),
(1700, 'wait interface', 'Books'),
(1666, 'harry potter', 'toys');

-- 3.
select * from products limit 1;
select * from products limit 3;
select * from products;

-- 4.
update products set product_id=product_id-1000 where product_id>1600;
select * from products;

-- 5.
delete from products where category='toys';
select * from products;

-- 6.
delete from products;
select * from products;

-- 7.
drop table products;