表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分钟内的所有数据】?
这个语句效率可能有点低,不过功能是达到了