riaDB [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 | +---------+-------------+----------------------+---------------+------------+ 2 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 | Basketball | bball.jpg | Orange and round | 40.00 | 4 | B001 | 11 | | 2 | Cranberry | cranberry.jpg | Sweet but tart | 100.00 | 3 | c001 | 10 | | 3 | Dog | dog.jpg | Pupperfluffer woof woof | 200.00 | 5 | D001 | 1 | | 4 | Eclair | eclair.jpg | My mom likes them | 4.99 | 4 | E001 | 100 | | 5 | Flounder | flounder.jpg | Doesn't come with water | 50.00 | 4 | f001 | 0 | | 6 | Greyscale | greyscale.jpg | Fictional disease would not recommend | 1.00 | 1 | g001 | 1 | +---------+------------+---------------+---------------------------------------+------------+-------------+----------+------------+ 6 rows in set (0.00 sec)