多表关联更新
最近更新时间: 2025-02-18 16:02:00
postgres=# update tbase set nickname ='Good TDSQL PG' from t_appoint_col where t_appoint_col.id=tbase.id;
UPDATE 1
postgres=# select * from tbase;
id | nickname
----+------------
2 | TDSQL PG好
1 | Good TDSQL PG
(2 rows)