查看表建立时的创建信息

mysql> show create table student
    -> ;
+---------+---------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------+
| Table   | Create Table

                                                |
+---------+---------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------+
| student | CREATE TABLE `student` (
  `StudentID` int(11) NOT NULL,
  `StudentName` varchar(20) NOT NULL,
  `StudentType` int(11) NOT NULL,
  PRIMARY KEY (`StudentID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+---------+---------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------+
1 row in set (0.08 sec)

mysql>