1.MySQL：BETWEEN 误区

语法：between...and...

1.简单实例：

SELECT * from t_user_m WHERE

create_time BETWEEN "2018-09-15 00:00:00" "2018-09-24 00:00:00"

结果：出现语法错误

2. 增加条件实例：

SELECT * from t_user_m WHERE

create_time BETWEEN "2018-09-15 00:00:00" "2018-09-24 00:00:00"

AND is_del=0

结果：查询成功

3. 进一步增加条件实例：

examle1 >>

SELECT * from t_user_m WHERE

create_time BETWEEN "2018-09-15 00:00:00" "2018-09-24 00:00:00"

AND is_del=0 AND page_no = 1 AND  type=1

examle2 >>

SELECT * from t_user_m WHERE

create_time BETWEEN "2018-09-15 00:00:00" "2018-09-24 00:00:00"

AND is_del=0 AND  type=1 AND page_no = 1

注意： where的条件顺序不同，会出现不同的查询结果。追加between...and...，

结果就会相同。以此提醒自己。

正确例子：

SELECT * from t_user_m WHERE

create_time BETWEEN "2018-09-15 00:00:00" AND "2018-09-24 00:00:00"

AND is_del=0 AND type=1 AND page_no = 1