多表关联删除数据
最近更新时间: 2025-02-18 16:02:00
postgres=# select * from tbase;
id | nickname
----+-------------
2 | TDSQL PG好
1 | Hello TDSQL PG
(2 rows)
postgres=# set prefer_olap to on;
SET
postgres=# delete from tbase using t_appoint_col where tbase.id=t_appoint_col.id;
DELETE 1
postgres=# select * from tbase;
id | nickname
----+-----------
2 | TDSQL PG好
(1 row)