mysql> SELECT CONCAT("Calculated difference between id ",t1.id," and id ",t2.id," is ",TIMESTAMPDIFF(SECOND,t1.time,t2.time)," seconds") AS difference FROM example AS t1, example AS t2 WHERE t1.id<t2.id GROUP BY t1.id ORDER BY t1.id;
+-------------------------------------------------------------+
| difference |
+-------------------------------------------------------------+
| Calculated difference between id 1 and id 6 is 2346 seconds |
| Calculated difference between id 3 and id 6 is 1185 seconds |
| Calculated difference between id 4 and id 6 is 1172 seconds |
| Calculated difference between id 5 and id 6 is 1161 seconds |
| Calculated difference between id 6 and id 7 is 2 seconds |
| Calculated difference between id 7 and id 8 is 1 seconds |
| Calculated difference between id 8 and id 11 is 4 seconds |
| Calculated difference between id 11 and id 12 is 2 seconds |
| Calculated difference between id 12 and id 14 is 3 seconds |
| Calculated difference between id 14 and id 15 is 1 seconds |
| Calculated difference between id 15 and id 16 is 2 seconds |
+-------------------------------------------------------------+