关于：between边界の话题！

mysql中between的边界,范围说明

• 延续颓废 发布于 2021-06-08 14:34
• 收藏 mysql between边界 between范围

mysql between的边界范围between 的范围是包含两边的边界值eg： id between 3 and 7 等价与 id >=3 and id<=7not between 的范围是不包含边界值eg：id not between 3 and 7 等价与 id < 3 or id>7SELECT * FROM `test` where id BETWEEN 3 and 7;等..