select * from zaiko where createtime between (now() - interval '3 Days') and now() ; select * from zaiko where createtime between (now() - interval '5 Mins') and now()
ps经过实际核实,这方法有毛病,刚入的数据,几十秒之后才能刷的出来
select * from zaiko where createtime between (now() - interval '3 Days') and now() ; select * from zaiko where createtime between (now() - interval '5 Mins') and now()
ps经过实际核实,这方法有毛病,刚入的数据,几十秒之后才能刷的出来
转载于:https://www.cnblogs.com/xiaoliu66007/p/11345137.html