Home >Database >Mysql Tutorial >mysql两日期之间数据查询语句
mysql两日期之间数据查询语句
- WBOYOriginal
- 2016-06-07 17:51:121181browse
本文章简单的介绍了关于在mysql数据库中如何来实现查询2个日期之间的数据，下面我们来看实例。
| 代码如下 | 复制代码 |
|
SELECT * FROM `cangku` WHERE ((shijian>=’2011-1-13′) and (shijian |
|
查询当前月的数据：
| 代码如下 | 复制代码 |
|
* from tables where month(Date)=month(now()) |
|
很简单吧，第一种还可以利用between来实现，这里我也不说了自己测试吧。
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql随机取数据的几种高效率方法Next article：mysql性能优化参考