1.IN vs BETWEEN
BETWEEN:select * from tablename where dates between '2018-06-01' and '2018-07-01'
查询两个边界范围内符合条件的记录;
IN:select * from tablename where dates in ('2018-06-01','2018-07-01')
查询两个时刻符合条件的记录;
2.
1.IN vs BETWEEN
BETWEEN:select * from tablename where dates between '2018-06-01' and '2018-07-01'
查询两个边界范围内符合条件的记录;
IN:select * from tablename where dates in ('2018-06-01','2018-07-01')
查询两个时刻符合条件的记录;
2.