MariaDB [rphannavong]> 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 [rphannavong]> SELECT * FROM Users; +---------+------------+---------------+---------------+------------+ | user_id | user_uname | user_email | user_password | user_fname | +---------+------------+---------------+---------------+------------+ | 1 | test | test@test.com | testpassword | testfname | | 2 | rose | rose@rose.com | rosepassword | rosefname | +---------+------------+---------------+---------------+------------+ 2 rows in set (0.00 sec) MariaDB [rphannavong]> 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 [rphannavong]> SELECT * FROM Products; +---------+----------------+----------+------------------------------------+------------+-------------+-----------+------------+ | prod_id | prod_name | prod_img | prod_description | prod_price | prod_rating | prod_sku | prod_stock | +---------+----------------+----------+------------------------------------+------------+-------------+-----------+------------+ | 1 | Milk | 000001 | This is cow milk. | 2.34 | 3 | asd123fgh | 0 | | 2 | Orange Juice | 000002 | This is juice from an orange. | 4.34 | 5 | hjk234jkl | 5 | | 3 | Bottled Water | 000003 | This is water. Stay hydrated. | 1.50 | 1 | zxc345bnm | 25 | | 4 | Chocolate Milk | 000004 | This is milk flavored chocolate. | 5.50 | 2 | qwe456wer | 44 | | 5 | Hazelnut Latte | 000005 | This is a latte flavored hazelnut. | 7.69 | 4 | tyu567uio | 15 | | 6 | Mango Juice | 000006 | This juice from a mango. | 8.05 | 5 | dfg678vbh | 27 | +---------+----------------+----------+------------------------------------+------------+-------------+-----------+------------+ 6 rows in set (0.00 sec)