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经过实际核实,这方法有毛病,刚入的数据,几十秒之后才能刷的出来