Mysql具有多个查询具有NAND操作和NOT操作

本文介绍了Mysql具有多个查询具有NAND操作和NOT操作的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我尝试在查询之间实现和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

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' );