本文介绍了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 $ c $应该用 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操作
发布评论