mysql> describe users;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| username   | varchar(30) | NO   | PRI |         |       |
| first_name | varchar(15) | NO   |     |         |       |
| last_name  | varchar(15) | NO   |     |         |       |
| email      | varchar(30) | NO   |     |         |       |
| date       | datetime    | NO   |     |         |       |
| password   | varchar(40) | NO   |     |         |       |
+------------+-------------+------+-----+---------+-------+
6 rows in set (0.02 sec)



mysql> select * from users;
+----------+------------+-----------+--------------------------+---------------------+------------------------------------------+
| username | first_name | last_name | email                    | date                | password                                 |
+----------+------------+-----------+--------------------------+---------------------+------------------------------------------+
| jeib     | Iyad       | Abu-Jeib  | abu-jeib@cs.fredonia.edu | 2006-11-02 22:59:25 | a9993e364706816aba3e25717850c26c9cd0d89d |
+----------+------------+-----------+--------------------------+---------------------+------------------------------------------+
1 row in set (0.00 sec)