![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
Celia_CiCi
女猿
展开
-
dos命令连接mysql
mysql -h 192.168.1.200 -u root -p 输入密码 show databases; use eyoudb; 操作表和字段原创 2014-01-09 10:08:15 · 2931 阅读 · 0 评论 -
mysql按照时间查询
mysql中如何查询最近24小时、 where visittime >= NOW() - interval 1 hour; 昨天、 where visittime between CURDATE()-interval 1 day and CURDATE(); 最近7天、 where visittime between CURDATE()-interval 7 day ;转载 2014-11-24 10:19:10 · 968 阅读 · 0 评论