MariaDB [dleinker]> show tables
    -> ;
+--------------------+
| Tables_in_dleinker |
+--------------------+
| products           |
| users              |
+--------------------+
2 rows in set (0.00 sec)

MariaDB [dleinker]> desc users
    -> ;
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| user_id       | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| user_uname    | varchar(255)     | YES  |     | NULL    |                |
| user_email    | varchar(255)     | YES  |     | NULL    |                |
| user_password | varchar(255)     | YES  |     | NULL    |                |
| user_fname    | varchar(255)     | YES  |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

MariaDB [dleinker]> SELECT * FROM users;
+---------+------------+-----------------+---------------+------------+
| user_id | user_uname | user_email      | user_password | user_fname |
+---------+------------+-----------------+---------------+------------+
|       1 | test       | test@test.com   | testpassword  | testfname  |
|       2 | dan        | dan@example.com | danpass       | dan        |
|       3 | d          | dan@example.com | d             | dan        |
+---------+------------+-----------------+---------------+------------+
3 rows in set (0.00 sec)

MariaDB [dleinker]> describe products;
+------------------+---------------------+------+-----+---------+----------------+
| Field            | Type                | Null | Key | Default | Extra          |
+------------------+---------------------+------+-----+---------+----------------+
| prod_id          | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| prod_name        | varchar(127)        | YES  |     | NULL    |                |
| prod_img         | varchar(127)        | YES  |     | NULL    |                |
| prod_description | varchar(511)        | YES  |     | NULL    |                |
| prod_price       | decimal(10,2)       | YES  |     | NULL    |                |
| prod_rating      | tinyint(3) unsigned | YES  |     | NULL    |                |
| prod_sku         | char(32)            | YES  |     | NULL    |                |
| prod_stock       | int(10) unsigned    | YES  |     | NULL    |                |
+------------------+---------------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)

MariaDB [dleinker]> SELECT * FROM products;
+---------+--------------------------------------+----------+-------------------------+------------+-------------+----------+------------+
| prod_id | prod_name                            | prod_img | prod_description        | prod_price | prod_rating | prod_sku | prod_stock |
+---------+--------------------------------------+----------+-------------------------+------------+-------------+----------+------------+
|       1 | Rubber Soul                          | img1.jpg | Beatles Album from 1965 |      19.99 |           5 | 123456   |          0 |
|       2 | Sgt. Peppers Lonely Hearts Club Band | img2.jpg | Beatles Album from 1967 |      39.99 |           4 | 12345116 |          5 |
|       3 | Abbey Rd.                            | img3.jpg | Beatles Album from 1969 |      23.99 |           3 | 12345116 |          5 |
|       4 | Revolver                             | img4.jpg | Beatles Album from 1966 |      14.99 |           2 | 12345116 |          2 |
|       5 | Magical Mystery Tour                 | img5.jpg | Beatles Album from 1967 |      39.99 |           0 | 12345116 |          5 |
|       6 | Let it Be                            | img6.jpg | Beatles Album from 1970 |       9.99 |           3 | 12345116 |          5 |
+---------+--------------------------------------+----------+-------------------------+------------+-------------+----------+------------+
6 rows in set (0.00 sec)