84669 personnes étudient
152542 personnes étudient
20005 personnes étudient
5487 personnes étudient
7821 personnes étudient
359900 personnes étudient
3350 personnes étudient
180660 personnes étudient
48569 personnes étudient
18603 personnes étudient
40936 personnes étudient
1549 personnes étudient
1183 personnes étudient
32909 personnes étudient
select o.* from user o where 1=1 and userId = 100041 and createTime between '2016-05-04' and '2016-05-06' order by o.createTime desc
始终缺少当天比如六号那天的记录,该怎么办?
估计默认的是 2016-05-06 00:00:00 了你用createTime between '2016-05-04 00:00:00' and '2016-05-06 23:59:59' 试试
select o.* from user o where 1=1 and userId = 100041 and createTime between '2016-05-04' and '2016-05-07' order by o.createTime desc
估计默认的是 2016-05-06 00:00:00 了
你用
createTime between '2016-05-04 00:00:00' and '2016-05-06 23:59:59' 试试
select o.* from user o where 1=1 and userId = 100041 and createTime between '2016-05-04' and '2016-05-07' order by o.createTime desc