mysql> describe users;
+-----------------+-------------+------+-----+---------+-------+
| Field           | Type        | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| username        | varchar(30) | NO   | PRI |         |       |
| password        | varchar(40) | NO   |     |         |       |
| question        | varchar(40) | NO   |     |         |       |
| answer          | varchar(40) | NO   |     |         |       |
| date            | datetime    | NO   |     |         |       |
| first_name      | varchar(15) | YES  |     | NULL    |       |
| last_name       | varchar(15) | YES  |     | NULL    |       |
| email           | varchar(40) | YES  |     | NULL    |       |
| phone           | varchar(20) | YES  |     | NULL    |       |
| address         | varchar(80) | YES  |     | NULL    |       |
| major           | varchar(20) | YES  |     | NULL    |       |
| graduation_year | int(4)      | YES  |     | NULL    |       |
+-----------------+-------------+------+-----+---------+-------+
12 rows in set (0.00 sec)



mysql> select * from users;
+----------+------------------------------------------+------------------------------+---------+---------------------+------------+-----------+--------------------------+----------------+-------------+----------+-----------------+
| username | password                                 | question                     | answer  | date                | first_name | last_name | email                    | phone          | address     | major    | graduation_year |
+----------+------------------------------------------+------------------------------+---------+---------------------+------------+-----------+--------------------------+----------------+-------------+----------+-----------------+
| jeib     | 1f8ac10f23c5b5bc1167bda84b833e5c057a77d2 | In which city you were born? | Lincoln | 2006-11-05 22:01:14 | Iyad       | Abu-Jeib  | abu-jeib@cs.fredonia.edu | 673-4757       | Fenton Hall | CS       |            1970 |
| jeib2    | 03de6c570bfe24bfc328ccd7ca46b76eadaf4334 | In which city you were born? | Denver  | 2006-11-05 22:03:22 | John       | Lewis     | alpha@beta.com           | (716) 673-4757 | Florida     | Comp Sci |            1980 |
| jeib3    | 03de6c570bfe24bfc328ccd7ca46b76eadaf4334 | In which city you were born? | Dunkirk | 2006-11-05 22:14:17 | Jarrod     | Smith     | a@b.c                    | 666-7777       | DC          | MATH     |            2000 |
+----------+------------------------------------------+------------------------------+---------+---------------------+------------+-----------+--------------------------+----------------+-------------+----------+-----------------+
3 rows in set (0.00 sec)