select *
from (
select 'CC23040108550343' as cc_task_code -- 数据作为已张表
) a
where a.cc_task_code not in(select DISTINCT( `cc_task_code`) from `t_consistency_cp` where `cc_task_code` is not null)
mysql单独数据作为一张表
深耕网站建设、视觉设计与SEO优化的一线实战洞察。
select *
from (
select 'CC23040108550343' as cc_task_code -- 数据作为已张表
) a
where a.cc_task_code not in(select DISTINCT( `cc_task_code`) from `t_consistency_cp` where `cc_task_code` is not null)