mysql> use test;
Database changed
mysql> describe people;
+-------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| it    | int(11)      |      | PRI | 0       |       |
| name  | varchar(255) | YES  |     | NULL    |       |
| bday  | date         | YES  |     | NULL    |       |
+-------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)