基本用法
show create table (目标表格)
结果为:
+-----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t_administrator | CREATE TABLE `t_administrator` (
`id` int(11) NOT NULL,
`authority` int(11) NOT NULL,
`password` varchar(255) DEFAULT NULL,
`userName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
下面这条语句则会对输出语句进行筛选
show create table t_administrator \G;
结果为:
*************************** 1. row ***************************
Table: t_administrator
Create Table: CREATE TABLE `t_administrator` (
`id` int(11) NOT NULL,
`authority` int(11) NOT NULL,
`password` varchar(255) DEFAULT NULL,
`userName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)