mysql> desc
introquiz1;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| idno | varchar(9) | | PRI | | |
| stuname |
varchar(35) | YES | | NULL
| |
| grade1 | int(3) | YES | | NULL
| |
| grade2 | int(3) | YES | | NULL
| |
| grade3 | int(3) | YES | | NULL
| |
+---------+-------------+------+-----+---------+-------+
5 rows in set (0.00
sec)
mysql> select *
from introquiz1;
+-------+-----------------+--------+--------+--------+
| idno | stuname | grade1 | grade2 | grade3 |
+-------+-----------------+--------+--------+--------+
| 11111 | Doe/John
M | 20 | 20 | 20 |
| 22222 |
Grove/Sara | 20 |
NULL | NULL |
| 33333 |
Daniels/Stephen | NULL | NULL |
NULL |
| 44444 |
Ames/Jennifer | 20 |
26 | 40 |
| 55555 |
Hersey/Carl | NULL |
NULL | NULL |
| 66666 |
Richards/Al | NULL |
NULL | NULL |
+-------+-----------------+--------+--------+--------+
6 rows in set (0.00 sec)