MySQL关于between and 和 大于等于>= 小于等于<=,你所会忽略的细节
其实这两种SQL用法在大多数情况下都是一样的,比如:
SELECT
*
FROM
employees
WHERE
employee_id >= 50 AND employee_id<=60;
和
SELECT
*
FROM
employees
WHERE
employee_id BETWEEN 50 AND 60;
查询出来的结果一样!都可以查询出employees表中employee_id在50-60之间的员工(包括50和60)
但是!
SELECT
*
FROM
employees
WHERE
employee_id >= 60 AND employee_id<=50;
和
SELECT
*
FROM
employees
WHERE
employee_id BETWEEN 60 AND 50;
结果不同! BETWEEN 60 AND 50这一句SQL语句则会查不到任何数据
总结:
①使用between and 可以提高语句的简洁度
②between and包含临界值(即包含两个边界值)
③between and的两个临界值不要乱调换顺序(数值小的放前面,数值大的放后面)