Mysql具有多个查询具有NAND操作和NOT操作 [英] Mysql with multiple query having NAND opertaion and NOT operation

问题描述

我尝试在查询之间实现和NOT操作和NAND操作。

I am trying to achieve and NOT operation and NAND operation in between Queries.

 SELECT 
    country_name,country_code 
       from country 
       where not (country_name='Land islands' and country_code='AX');

当我尝试

 SELECT * from
   country 
     where not 
       (SELECT * from country 
              where country_name='Land islands' 
        and 
        SELECT * from country
               where country_code='AX');

显示错误..

请参考链接：与我上一个问题和NOT和NAND的工作操作。

Kindly refer the Link: With my previous question and the working of NOT and NAND operation.

MySQL NAND /查询中的NOR操作

推荐答案

AND UNION 和表格的主键（让它假设 id NOT IN 子句检查。

AND should be replaced by UNION and the primary key of table (let it assume id) should be checked with NOT IN clause.

SELECT * from country 
WHERE id NOT IN
       (SELECT id from country 
              where country_name='Land islands' 
        UNION
        SELECT id from country
               where country_code='AX'
        );

这篇关于Mysql具有多个查询具有NAND操作和NOT操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！