无涯教程-MySQL - NOT 语句 MySQL NOT条件与MySQL IN条件相反。它用于取消SELECT，INS

MySQL NOT条件与MySQL IN条件相反。它用于取消SELECT，INSERT，UPDATE或DELETE语句中的条件。

NOT condition

condition - 它指定要取消的条件。

NOT IN 查询

考虑具有以下数据的表"officers"。

执行以下查询:

SELECT *
FROM officers
WHERE officer_name NOT IN (Ajeet,Vimal,Deepika);

输出:

执行以下查询:

SELECT *
FROM officers
WHERE officer_name IS NOT NULL;

输出:

无涯教程还将同一张表"officers"用于此操作:

执行以下查询:

SELECT *
FROM officers
WHERE officer_name NOT LIKE A%;

输出:

无涯教程还将同一张表"officers"用于此操作:

执行以下查询:

SELECT *
FROM officers
WHERE officer_id NOT BETWEEN 3 AND 5;

输出: