记录

新增记录。

INSERT INTO products (name, price, description) VALUES ('苹果', '15', '美味');
INSERT INTO products (name, price, description) VALUES ('香蕉', '20', '香气');
INSERT INTO products (name, price, description) VALUES ('菠萝', '25', '可口');

查询记录。

SELECT * FROM products;

id	name	price	description
1	苹果	$15.00	美味
2	香蕉	$20.00	香气
3	菠萝	$25.00	可口

(3 rows)

修改记录。

UPDATE products SET price = '28' WHERE name = '菠萝';

UPDATE 1

查询记录。

SELECT * FROM products;

id	name	price	description
1	苹果	$15.00	美味
2	香蕉	$20.00	香气
3	菠萝	$28.00	可口

(3 rows)

删除记录

DELETE FROM products WHERE name = '菠萝';

DELETE 1

查询记录。

SELECT * FROM products;

id	name	price	description
1	苹果	$15.00	美味
2	香蕉	$20.00	香气

(2 rows)