MariaDB [jtrigueros]> desc 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 [jtrigueros]> SELECT * FROM Products; +---------+------------------------+--------------+---------------------------------------+------------+-------------+----------+------------+ | prod_id | prod_name | prod_img | prod_description | prod_price | prod_rating | prod_sku | prod_stock | +---------+------------------------+--------------+---------------------------------------+------------+-------------+----------+------------+ | 1 | TD-04 15T Turbo | turbo.jpg | Later Model Turbo | 379.00 | 5 | 1 | 21 | | 2 | Valance(Quarter Panel) | valance.jpg | 99-09 9-5 Valance Replacement | 347.00 | 4 | 2 | 3 | | 3 | Upper Engine Mount | mount.jpg | 99-09 9-5 Upper Engine Mount | 77.31 | 5 | 3 | 27 | | 4 | Hood Emblem | emblem.jpg | 99-09 9-5 Custom Hood Emblem | 12.41 | 1 | 4 | 10 | | 5 | ProParts Trans Mount | props.jpg | 99-09 9-5 ProParts Transmission Mount | 28.99 | 2 | 5 | 44 | | 6 | Throttle Body | throttle.jpg | 99-09 9-5 Throttle Body | 467.52 | 3 | 6 | 5 | +---------+------------------------+--------------+---------------------------------------+------------+-------------+----------+------------+ 6 rows in set (0.00 sec) MariaDB [jtrigueros]> 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 [jtrigueros]> SELECT * FROM Users; +---------+------------+-----------------+----------------+------------+ | user_id | user_uname | user_email | user_password | user_fname | +---------+------------+-----------------+----------------+------------+ | 1 | test | test@test.com | testpassword | testfname | | 2 | Jsmith | Jsmith@test.com | Jsmithpassword | John Smith | +---------+------------+-----------------+----------------+------------+ 2 rows in set (0.00 sec)