Skip to content

Instantly share code, notes, and snippets.

@jordanlewis
Created December 6, 2016 21:54
Show Gist options
  • Save jordanlewis/207a0f267dfc55fdb471187d2815c33c to your computer and use it in GitHub Desktop.
Save jordanlewis/207a0f267dfc55fdb471187d2815c33c to your computer and use it in GitHub Desktop.
root@:26257> set database=company;
SET
root@:26257> show tables;
+----------------+
| Table |
+----------------+
| PRODUCT_ORDERS |
| customers |
| orders |
| products |
+----------------+
(4 rows)
root@:26257> select * from product_orders;
+----------+------------+
| ORDER_ID | PRODUCT_ID |
+----------+------------+
+----------+------------+
(0 rows)
root@:26257> select * from customers;
+--------------------+------+
| ID | NAME |
+--------------------+------+
| 199854102714449921 | joe |
+--------------------+------+
(1 row)
root@:26257> select * from orders;
+--------------------+----------+--------------------+
| ID | SUBTOTAL | CUSTOMER_ID |
+--------------------+----------+--------------------+
| 199854102749380609 | 100 | 199854102714449921 |
+--------------------+----------+--------------------+
(1 row)
root@:26257> select * from products;
+----+------+---------+
| ID | NAME | PRODUCT |
+----+------+---------+
+----+------+---------+
(0 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment