isip003_[2]: /opt/mysql/bin/mysql -pisipy2k -uadmin
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 870 to server version: 3.22.15-gamma-log

Type 'help' for help.

mysql> connect ece_4512_ppd
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Connection id:    871
Current database: ece_4512_ppd

mysql> show tables;
+------------------------+
| Tables in ece_4512_ppd |
+------------------------+
| projects               |
| users                  |
+------------------------+
2 rows in set (0.01 sec)

mysql> describe projects;
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| pNum     | int(10)     |      | PRI | 0       | auto_increment |
| semester | varchar(15) |      | PRI |         |                |
| title    | varchar(80) | YES  |     | NULL    |                |
| descr    | blob        | YES  |     | NULL    |                |
+----------+-------------+------+-----+---------+----------------+
4 rows in set (0.02 sec)

mysql> describe users;
+----------+-------------------+------+-----+---------+-------+
| Field    | Type              | Null | Key | Default | Extra |
+----------+-------------------+------+-----+---------+-------+
| pNum     | int(10)           |      | PRI | 0       |       |
| semester | varchar(15)       |      | PRI |         |       |
| name     | varchar(80)       | YES  |     | NULL    |       |
| email    | varchar(80)       | YES  |     | NULL    |       |
| role     | enum('L','M','A') | YES  |     | NULL    |       |
+----------+-------------------+------+-----+---------+-------+
5 rows in set (0.02 sec)

mysql> quit
Bye
isip003_[2]: