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>