riaDB [abainbridge]> Use abainbridge
Database changed
MariaDB [abainbridge]> describe 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 [abainbridge]> 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 [abainbridge]> SELECT * FROM Users; 
+---------+-------------+----------------------+---------------+------------+
| user_id | user_uname  | user_email           | user_password | user_fname |
+---------+-------------+----------------------+---------------+------------+
|       1 | test        | test@test.com        | testpassword  | testfname  |
|       2 | abainbridge | abainbridge@csub.com | password      | andrew     |
|       3 | a           |                      | ab            | Andrew     |
|       4 | derrick     |                      | isgreat       |            |
|       5 | extra       |                      | credit?       |            |
+---------+-------------+----------------------+---------------+------------+
5 rows in set (0.00 sec)

MariaDB [abainbridge]> SELECT * FROM Products; 
+---------+-----------------------+-------------+--------------------------+------------+-------------+----------+------------+
| prod_id | prod_name             | prod_img    | prod_description         | prod_price | prod_rating | prod_sku | prod_stock |
+---------+-----------------------+-------------+--------------------------+------------+-------------+----------+------------+
|       1 | Lebron                | lebron.jpg  | Best player in the world |     150.00 |           4 | LJ0001   |         11 |
|       2 | Steph Curry           | steph.jpg   | Best shooter of all time |     150.00 |           3 | SC0001   |         10 |
|       3 | James Harden          | james.jpg   | Has beard                |     125.00 |           5 | JH0001   |          1 |
|       4 | Russell Westbrook     | russell.jpg | Crap playoff performance |     100.00 |           4 | RW0001   |        100 |
|       5 | Giannis Antetokounmpo | giannis.jpg | Next face of the NBA     |     150.00 |           4 | GA001    |          0 |
|       6 | Kyrie Irving          | kyrie.jpg   | Woke?                    |     150.00 |           1 | KI001    |          1 |
+---------+-----------------------+-------------+--------------------------+------------+-------------+----------+------------+
6 rows in set (0.00 sec)

MariaDB [abainbridge]>