PostgreSQL使用delete删除数据的时候关联多个表
PostgreSQL使用delete删除数据的时候关联多个表
看个例子就知道了
删除game_pg_getpoint表中的数据,需要关联getpoint表
- 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
评论暂时关闭