mysql 里，随便写两个语句嵌套的。

最新推荐文章于 2024-08-13 20:05:22 发布

code-jam

最新推荐文章于 2024-08-13 20:05:22 发布

阅读量776

点赞数

分类专栏：数据库文章标签： mysql

本文链接：https://blog.csdn.net/festone000/article/details/79815524

版权

数据库专栏收录该内容

53 篇文章 1 订阅

订阅专栏

msyql 5.7 社区版。

SELECT
* 
from 
user_detail ud
WHERE
ud.pk not in (SELECT lwl.uid from lucky_wheel_log lwl WHERE lwl.time > '2018-03-24 00:00:00' AND lwl.time  < '2018-04-01 00:00:00');
-- 

SELECT
lwl.uid as uid
FROM
 lucky_wheel_log lwl 
WHERE
lwl.time > '2018-03-24 00:00:00' AND lwl.time  < '2018-04-01 00:00:00'
AND
lwl.bonus_desc like '%卡%'
AND
lwl.uid not in (SELECT DISTINCT bwr.user_id from bid_winning_record bwr WHERE bwr.bid_time  > '2018-03-24 00:00:00' AND bwr.bid_time  < '2018-04-01 00:00:00')