Skip to content

Instantly share code, notes, and snippets.

@beppu
Created January 13, 2011 21:36
Show Gist options
  • Select an option

  • Save beppu/778664 to your computer and use it in GitHub Desktop.

Select an option

Save beppu/778664 to your computer and use it in GitHub Desktop.
notice the 0s in the day column
mysql> select * from purchase_item where purchase_id = 2;
+----+-------------+-----+---------+------------+-------------+-------+---------------------+---------------------+
| id | purchase_id | day | t | child_name | child_grade | price | created_on | modified_on |
+----+-------------+-----+---------+------------+-------------+-------+---------------------+---------------------+
| 37 | 2 | 0 | regular | Bill | 0 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 38 | 2 | 0 | regular | Bill | 0 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 39 | 2 | 0 | regular | Bill | 0 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 40 | 2 | 0 | regular | Bill | 0 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 41 | 2 | 0 | regular | Bill | 0 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 42 | 2 | 0 | regular | Bill | 0 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 43 | 2 | 11 | regular | Bill | 0 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 44 | 2 | 14 | regular | Bill | 0 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 45 | 2 | 15 | regular | Bill | 0 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 46 | 2 | 16 | regular | Bill | 0 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 47 | 2 | 18 | regular | Bill | 0 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 48 | 2 | 21 | regular | Bill | 0 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 49 | 2 | 22 | regular | Bill | 0 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 50 | 2 | 23 | regular | Bill | 0 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 51 | 2 | 25 | regular | Bill | 0 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 52 | 2 | 28 | regular | Bill | 0 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 53 | 2 | 0 | regular | Melinda | 1 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 54 | 2 | 0 | regular | Melinda | 1 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 55 | 2 | 0 | regular | Melinda | 1 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 56 | 2 | 0 | regular | Melinda | 1 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 57 | 2 | 0 | regular | Melinda | 1 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 58 | 2 | 0 | regular | Melinda | 1 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 59 | 2 | 11 | regular | Melinda | 1 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 60 | 2 | 14 | regular | Melinda | 1 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 61 | 2 | 15 | regular | Melinda | 1 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 62 | 2 | 16 | regular | Melinda | 1 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 63 | 2 | 18 | regular | Melinda | 1 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 64 | 2 | 21 | regular | Melinda | 1 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 65 | 2 | 22 | regular | Melinda | 1 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 66 | 2 | 23 | regular | Melinda | 1 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 67 | 2 | 25 | regular | Melinda | 1 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
| 68 | 2 | 28 | regular | Melinda | 1 | 5.00 | 2011-01-13 13:08:56 | 2011-01-13 15:08:56 |
+----+-------------+-----+---------+------------+-------------+-------+---------------------+---------------------+
32 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment