mysql> explain books;
+-----------+------------------+------+-----+---------+----------------+
| Field     | Type             | Null | Key | Default | Extra          |
+-----------+------------------+------+-----+---------+----------------+
| id        | int(11) unsigned | NO   | PRI | NULL    | auto_increment |
| title     | varchar(40)      | YES  |     | NULL    |                |
| author    | varchar(40)      | YES  |     | NULL    |                |
| available | tinyint(1)       | YES  |     | NULL    |                |
+-----------+------------------+------+-----+---------+----------------+
4 rows in set (0.01 sec)

mysql> select * from books;
+----+----------------------------------------+----------------------+-----------+
| id | title                                  | author               | available |
+----+----------------------------------------+----------------------+-----------+
|  1 | The Hitchhiker's Guide to the Galaxy   | Douglas Adams        |         1 |
|  2 | PHP and MySQL For Dummies, 3rd Edition | Janet Valade         |         1 |
|  3 | Database Systems: The Complete Book    | Hector Garcia-Molina |         0 |
+----+----------------------------------------+----------------------+-----------+
3 rows in set (0.00 sec)

mysql>