weixin_43857576的博客

select * from A6_data where date_sub(CURDATE(),INTERVAL 7 DAY) <= DATE(col_time) AND instruction_type = ‘A6’;-- 查询最新一条数据SELECT * FROM apple ORDER BY id DESC LIMIT 1;-- 今天 select * from apple where to_days(data_time) = to_days(now()); -- 昨天 selec