mysql> 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.01 sec) mysql> select * from Users -> ; +---------+------------+-------------------+---------------+------------+ | user_id | user_uname | user_email | user_password | user_fname | +---------+------------+-------------------+---------------+------------+ | 1 | test | test@test.com | testpassword | testfname | | 2 | saustin | spencer@austin.vg | password | spencer | +---------+------------+-------------------+---------------+------------+ 2 rows in set (0.00 sec) mysql> 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.01 sec) mysql> select * from Products -> ; +---------+-----------------------------+----------------+---------------------------------------------+------------+-------------+----------+------------+ | prod_id | prod_name | prod_img | prod_description | prod_price | prod_rating | prod_sku | prod_stock | +---------+-----------------------------+----------------+---------------------------------------------+------------+-------------+----------+------------+ | 14 | New Balance 2040v3 Leather | 2040v3.jpg | The pinnacle of style and comfort | 400.00 | 4 | NB00001 | 1 | | 15 | Jordan Super Fly 5 iD | superfly.jpg | Custom made and simply the best | 190.00 | 3 | JD00001 | 0 | | 16 | Adidas Ultraboost Uncaged | ultraboost.jpg | Like wearing a sock, but its a shoe | 200.00 | 5 | RE00001 | 1 | | 17 | Reebok JJI Insomnia Edition | insomnia.jpg | Fusion of style and comfort | 99.99 | 5 | RE00001 | 1 | | 18 | Under Armour Bandit | bandit.jpg | Light breathable and extremely stretchable | 89.00 | 4 | UU00001 | 1 | | 26 | Nike Air Max Sequent 2 | sequent.jpg | Great all purpose training shoe | 100.00 | 3 | NAM001 | 2 | +---------+-----------------------------+----------------+---------------------------------------------+------------+-------------+----------+------------+ 6 rows in set (0.00 sec) mysql>