MySQL如何查看表的创建语句

mysql> show create table books;
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                      |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| books | CREATE TABLE `books` (
  `name` varchar(30) DEFAULT NULL,
  `author` varchar(20) DEFAULT NULL,
  `jb` varchar(20) DEFAULT NULL,
  KEY `books_index_name` (`name`,`author`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)