1,BETWEEN … AND 相当于 >= AND <= 因此包含两端的值
select id from customers where id between 100 and 105;
执行结果
2,操作符 BETWEEN … AND 会选取介于两个值之间的数据范围。这些值可以是数值、文本或者日期
select report_date
from customer_report_daily
where customer_id=14 and report_date between '2017-01-10' and '2017-01-15';