进行更新删除操作
更新时间 2025-02-05 09:37:13
最近更新时间: 2025-02-05 09:37:13
本页为您介绍对表进行更新删除的操作。
teledb=# DELETE FROM foo WHERE bar = 1;
DELETE 1
teledb=# DELETE FROM foo WHERE bar = 2;
DELETE 1
teledb=# update foo set baz = 'ccc_new' where bar = 3;
UPDATE 1
teledb=# update foo set baz = 'ccc_new2' where bar = 3;
UPDATE 1
teledb=# insert into foo(bar, baz) values (5,'eee');
INSERT 0 1
teledb=# insert into foo(bar, baz) values (6,'fff');
INSERT 0 1
teledb=# delete from foo where bar = 6;
DELETE 1
teledb=# select * from foo;
bar | baz
-----+----------
5 | eee
3 | ccc_new2
(2 rows)
