mysql 时间查询 2020/08/23 | mysql | 评论(0) | 阅读(351) <div>查询当天数据:</div> <div>$sql = "SELECT id,apmac,devmac,rssi,createtime from sm_rssi WHERE date_format(from_UNIXTIME(createtime),'%Y-%m-%d') = DATE_FORMAT(now(),'%Y-%m-%d')";</div> <div></div> <div>查询一周的数据:</div> <div>$sql = "SELECT *, sum(cost_...