mysql - 从单个日期时间列创建开始列和结束列

Question

我想从名为 tbl 的表中的单个 MySQL 日期时间列中选择一个开始列和一个结束列。有什么建议吗？

我从什么开始:

+---------------------+
|      date_time      |
+---------------------+
| 2012-03-05 10:15:52 |
| 2012-03-05 10:15:53 |
| 2012-03-05 10:15:54 |
+---------------------+  

想要的结果:

+---------------------+---------------------+
|     start_time      |      end_time       |
+---------------------+---------------------+
| 2012-03-05 10:15:52 | 2012-03-05 10:15:53 |
| 2012-03-05 10:15:53 | 2012-03-05 10:15:54 |
+---------------------+---------------------+

Answer 1

SELECT   cur.date_time AS start_time, MIN(nxt.date_time) AS end_time
FROM     my_table AS cur JOIN my_table AS nxt ON nxt.date_time > cur.date_time
GROUP BY cur.date_time

查看sqlfiddle .