Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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)
Add Comment
Please, Sign In to add comment