表test,结构如下
+-------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| t1 | datetime | NO | | NULL | |
| t2 | int(11) | NO | | NULL | |
+-------+----------+------+-----+---------+----------------+值如下:
+----+---------------------+------------+
| id | t1 | t2 |
+----+---------------------+------------+
| 1 | 2013-10-22 15:26:41 | 1382426801 |
| 2 | 2013-10-22 15:27:10 | 1382426830 |
| 3 | 2013-10-22 15:27:28 | 1382426848 |
| 4 | 2013-10-22 15:27:34 | 1382426854 |
| 5 | 2013-10-22 15:27:39 | 1382426859 |
| 6 | 2013-10-22 15:28:01 | 1382426881 |
| 7 | 2013-10-22 15:28:06 | 1382426886 |
| 8 | 2013-10-22 15:28:07 | 1382426887 |
| 9 | 2013-10-22 15:28:07 | 1382426887 |
| 10 | 2013-10-22 15:28:08 | 1382426888 |
| 11 | 2013-10-22 15:28:09 | 1382426889 |
+----+---------------------+------------+请问,如何查询出【当前最大时间1分钟内的所有数据】?
+-------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| t1 | datetime | NO | | NULL | |
| t2 | int(11) | NO | | NULL | |
+-------+----------+------+-----+---------+----------------+值如下:
+----+---------------------+------------+
| id | t1 | t2 |
+----+---------------------+------------+
| 1 | 2013-10-22 15:26:41 | 1382426801 |
| 2 | 2013-10-22 15:27:10 | 1382426830 |
| 3 | 2013-10-22 15:27:28 | 1382426848 |
| 4 | 2013-10-22 15:27:34 | 1382426854 |
| 5 | 2013-10-22 15:27:39 | 1382426859 |
| 6 | 2013-10-22 15:28:01 | 1382426881 |
| 7 | 2013-10-22 15:28:06 | 1382426886 |
| 8 | 2013-10-22 15:28:07 | 1382426887 |
| 9 | 2013-10-22 15:28:07 | 1382426887 |
| 10 | 2013-10-22 15:28:08 | 1382426888 |
| 11 | 2013-10-22 15:28:09 | 1382426889 |
+----+---------------------+------------+请问,如何查询出【当前最大时间1分钟内的所有数据】?
解决方案 »
- phpadmin为什么总是显示 MySQL 字符集: cp1252 West European (latin1)
- 为什么innodb_pool_buffer_size的最大值只能到4G
- 拷贝表文件数据库可以读吗?(急急!!)
- Mysql 安装时的问题
- Fedora 8下安装MySQL
- 存储过程问题
- 请教MYSQL最新版本数据库 支持的存储容量的上限和表数目的上限
- 如何备份数据库
- 把sqlserver的脚本 改成mysql的
- 谁有关于apache+php+mysql和pws+php+mysql安装配置的详细文档资料!
- 如何得到一天中每10分钟的时间
- MySql Workbench 6.0 导出数据库后不能导入的问题
这个语句效率可能有点低,不过功能是达到了