PostgreSQL 使用 delete 删除数据的时候关联多个表
程序员文章站
2022-06-08 13:45:41
...
删除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
上一篇: yii 表单 还可以是两列啊该如何解决
下一篇: MySQL安全问题一点心得_MySQL