-- 查询昨天的登陆数据 ,DATE(),DATE_SUB(),CURDATE(),
SELECT * FROM t_record_login WHERE (DATE(createtime) = DATE_SUB(CURDATE(),INTERVAL 1 DAY) AND resourcetype = 6)
-- 查询昨天的登陆数据 ,DATE(),DATE_SUB(),CURDATE(),
SELECT * FROM t_record_login WHERE (DATE(createtime) = DATE_SUB(CURDATE(),INTERVAL 1 DAY) AND resourcetype = 6)