qq_34807722的博客

SELECTn.id,n.userid,n.addtime,n.title,n.titlepic,n.intro,n.sharenum,n.supportnum,n.opposenum,n.type,n.status,n.commentnum,n.cid,n.siteid,n.legitimate,n.reserve1,n.reserve2,nd.textFR...

id, username, password select from user where id = #{id,jdbcType=INTEGER}

查询今日数据select * from t_time where TO_DAYS(NOW()) - to_days(time) <1查询昨日数据SELECT * FROM t_time WHERE TO_DAYS( NOW( ) ) - TO_DAYS( time) =1查询近七天数据SELECT * FROM t_time where DATE_SUB(CURDATE(), IN...

https://blog.youkuaiyun.com/hj7jay/article/details/51686418