mysql not_MySQL not between and关键字简介说明

摘要:

下文讲述MySQL not between and 关键字的用法及功能说明，如下所示:

not between and关键字功能说明

用于显示不在范围内的数据。

其功能类似于 小于前边界 或大于后边界的数据信息

not between and关键字举例应用

mysql > select * from `maomao365.com`;

+-------+------------+

| keyId | infoB |

+-------+------------+

| 1 | mysql test |

| 129 | sql |

| 12913 | sql |

| 12913 | sql |

| 12913 | sql |

+-------+------------+

5 rows in set (0.00 sec)

mysql > select * from `maomao365.com` where keyId not between 10000 and 20000;

+-------+------------+

| keyId | infoB |

+-------+------------+

| 1 | mysql test |

| 129 | sql |

+-------+------------+

2 rows in set (0.00 sec)