MySQL查看表结构有如下6种方式:
DESC 表名;
SHOW COLUMNS FROM 表名;
DESCRIBE 表名;
SHOW CREATE TABLE 表名;
USE INFORMATION_SCHEMA;
SELECT * FROM columns WHERE table_name='表名'
现在有一张表 rbt_role,使用以上每条语句查看一下该表的结构,结果显示在每条下面
-
DESC rbt_role
-
SHOW COLUMNS FROM rbt_role
-
DESCRIBE rbt_role
-
SHOW CREATE TABLE rbt_role
Table
Create Table rbt_role CREATE TABLE `rbt_role` ( `id` int(20) NOT NULL AUTO_INCREMENT, `role_name` varchar(20) NOT NULL, `role_desc` varchar(30) DEFAULT NULL, `creation_time` datetime DEFAULT NULL, `update_time` datetime DEFAULT NULL, `yn` int(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `RROLE_ROLE_NAME_INDEX` (`role_name`), KEY `RROLE_ROLE_DESC_INDEX` (`role_desc`), KEY `RROLE_YN_INDEX` (`yn`)) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8