Skip to content

Instantly share code, notes, and snippets.

@cjwfuller

cjwfuller/gist:241d0c4ee94bea4191ba

Created December 12, 2014 13:57
Show Gist options
  • Save cjwfuller/241d0c4ee94bea4191ba to your computer and use it in GitHub Desktop.
Save cjwfuller/241d0c4ee94bea4191ba to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> select * from orders where user_id = 8;
+----+---------------------+---------------------+---------+---------------------+-----------------+-----------+---------------------+-------+---------------------+---------------------+----------+---------------------+-----------+----------------+---------------------+--------------------+-----------------+
| id | created_at | updated_at | user_id | when_projected | subscription_id | period_id | when_committed | total | shipping_list_price | is_shipping_vatable | vat_rate | total_excluding_vat | total_vat | order_state_id | shipping_address_id | billing_address_id | delivery_day_id |
+----+---------------------+---------------------+---------+---------------------+-----------------+-----------+---------------------+-------+---------------------+---------------------+----------+---------------------+-----------+----------------+---------------------+--------------------+-----------------+
| 3 | 2014-12-12 12:25:44 | 2014-12-16 12:59:04 | 8 | 0000-00-00 00:00:00 | 6 | 49 | 2014-12-16 12:59:04 | 34.99 | 0.00 | 0 | 0.0000 | 34.99 | 0.00 | 2 | 9 | 9 | 194 |
| 7 | 2014-12-16 12:59:04 | 2014-12-23 13:22:01 | 8 | 0000-00-00 00:00:00 | 6 | 50 | 2014-12-23 13:22:01 | 34.99 | 0.00 | 0 | 0.0000 | 34.99 | 0.00 | 2 | 9 | 9 | 198 |
| 12 | 2014-12-23 13:22:01 | 2014-12-30 13:29:40 | 8 | 0000-00-00 00:00:00 | 6 | 51 | 2014-12-30 13:29:40 | 34.99 | 0.00 | 0 | 0.0000 | 34.99 | 0.00 | 2 | 9 | 9 | 202 |
| 17 | 2014-12-30 13:29:40 | 2015-01-05 13:37:58 | 8 | 0000-00-00 00:00:00 | 6 | 52 | 2015-01-05 13:37:58 | 0.00 | 0.00 | 0 | 0.0000 | 34.99 | 0.00 | 2 | 9 | 9 | 206 |
| 22 | 2015-01-05 13:37:58 | 2015-01-05 13:37:58 | 8 | 0000-00-00 00:00:00 | 6 | 53 | NULL | NULL | 0.00 | 0 | 0.0000 | NULL | NULL | 1 | NULL | NULL | 210 |
+----+---------------------+---------------------+---------+---------------------+-----------------+-----------+---------------------+-------+---------------------+---------------------+----------+---------------------+-----------+----------------+---------------------+--------------------+-----------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment