时间:2021-07-01 10:21:17 帮助过:486人阅读
删除game_pg_getpoint表中的数据,需要关联getpoint表 PostgreSQL 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_getpo
删除game_pg_getpoint表中的数据,需要关联getpoint表 PostgreSQLDELETE 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