您好,欢迎来到醉满楼美食网。
搜索
您的当前位置:首页PostgreSQL使用delete删除数据的时候关联多个表

PostgreSQL使用delete删除数据的时候关联多个表

来源:醉满楼美食网


删除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表 PostgreSQL $velocityCount-->
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 

Copyright © 2019- zuimanlou.com 版权所有

违法及侵权请联系:TEL:199 18 7713 E-MAIL:2724546146@qq.com

本站由北京市万商天勤律师事务所王兴未律师提供法律服务