Mysql Delete inner jion 删除数据

最新推荐文章于 2024-07-21 18:42:33 发布

米斯特程序猿

最新推荐文章于 2024-07-21 18:42:33 发布

阅读量9.1k

点赞数

分类专栏：随笔 MySQL

本文链接：https://blog.csdn.net/keplerpig/article/details/78674369

版权

随笔同时被 2 个专栏收录

72 篇文章 0 订阅

订阅专栏

MySQL

12 篇文章 0 订阅

订阅专栏

语法 DELETE 要删除数据表的别名 FROM 要删除的表 AS 别名 INNER JION 关联表A AS 别名A ON 别名.XX=别名A.XX WHERE 其它条件实例如下：

DELETE ch
FROM
	ch_withdraw AS ch
INNER JOIN ch_resource_set_resource crsr ON crsr.res_code = ch.res_code
AND ch.res_set_code = crsr.res_set_code
AND ch.channel_code = crsr.channel_code
INNER JOIN ch_resource cr ON crsr.res_code = cr.res_code
INNER JOIN ch_resource_langs crl ON cr.res_code = crl.res_code
WHERE
	crsr.`status` = '2'
AND cr.end_time <= NOW() AND IF(cr.end_time=NULL,0,1)=1