查看表建立时的创建信息

来源：互联网发布：相对湿度计算软件编辑：程序博客网时间：2024/06/02 23:14

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>