進行更新刪除操作
更新時間 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)
