PostgreSQL 使用 delete 删除数据的时候关联多个表
- 作者: 诸葛村妇主任
- 来源: 51数据库
- 2022-08-17
DELETE FROM game_pg_getpoint USING getpoint
WHERE (getpoint.fixflg = 1 OR game_pg_getpoint.immediately_flag=1)
AND game_pg_getpoint.memberid = getpoint.memberid
AND game_pg_getpoint.comment = getpoint.comment
AND game_pg_getpoint.thanksid = getpoint.thanksid
AND game_pg_getpoint.thanksname = getpoint.thanksname
AND game_pg_getpoint.getpoint_regist_date = getpoint.registdate
推荐阅读
