文章分类 -  MySql数据库

摘要：MYSql查詢一段時間記錄24小时内记录（即86400秒）$sql="SELECT video_id,count(id)as n FROM `rec_down` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(add_time)<=86400 group by video_id order by n desc ";$sql="select a.id,a.... 阅读全文