Skip to content

Instantly share code, notes, and snippets.

@jwarchol
Created January 11, 2010 19:02
Show Gist options
  • Save jwarchol/274480 to your computer and use it in GitHub Desktop.
Save jwarchol/274480 to your computer and use it in GitHub Desktop.
mysql> select * from entries where phone_id = 40;
+-----+----------+-------+---------+---------------------+---------------------+---------+
| id | phone_id | miles | gallons | created_at | updated_at | mpg |
+-----+----------+-------+---------+---------------------+---------------------+---------+
| 209 | 40 | 33318 | 19.295 | 2009-11-26 22:07:29 | 2009-11-26 22:07:29 | NULL |
| 210 | 40 | 33631 | 16.494 | 2009-11-28 22:11:21 | 2009-11-28 22:11:21 | 18.9766 |
| 212 | 40 | 34075 | 23.642 | 2009-12-05 01:24:18 | 2009-12-05 01:24:18 | 18.7801 |
| 213 | 40 | 34302 | 14.092 | 2009-12-06 18:27:38 | 2009-12-06 18:27:38 | 16.1084 |
| 215 | 40 | 34638 | 19.022 | 2009-12-10 23:36:49 | 2009-12-10 23:36:49 | 17.6638 |
| 218 | 40 | 35097 | 24.074 | 2009-12-18 17:34:43 | 2009-12-18 17:34:43 | 19.0662 |
| 220 | 40 | 35441 | 19.394 | 2009-12-24 05:06:45 | 2009-12-24 05:06:45 | 17.7374 |
| 222 | 40 | 35804 | 19.884 | 2010-01-01 02:08:29 | 2010-01-01 02:08:29 | 18.2559 |
| 224 | 40 | 36099 | 16.766 | 2010-01-09 15:13:13 | 2010-01-09 15:13:13 | 17.5951 |
+-----+----------+-------+---------+---------------------+---------------------+---------+
9 rows in set (0.08 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment