带条件删除
最近更新时间: 2025-02-18 16:02:00
postgres=# select * from tbase;
id | nickname
----+-------------
2 | TDSQL PG好
1 | Hello TDSQL PG
3 |
4 | TDSQL PG good
(4 rows)
postgres=# delete from tbase where id=4;
DELETE 1
#null条件的表达方式
postgres=# delete from tbase where nickname is null;
DELETE 1
postgres=# select * from tbase;
id | nickname
----+-------------
2 | TDSQL PG好
1 | Hello TDSQL PG
(2 rows)