时间: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