SHOW [FULL] COLUMNS FROM

SHOW [FULL] COLUMNS FROM <table_name> 语句用于以表格格式描述表或视图中的列。可选关键字 FULL 用于显示当前用户对该列的权限,以及表定义中的 comment

SHOW [FULL] FIELDS FROM <table_name>DESC <table_name>DESCRIBE <table_name>EXPLAIN <table_name> 语句都是 SHOW [FULL] COLUMNS FROM 的别名。

语法图

ShowStmt:

ShowStmt

ShowColumnsFilterable:

ShowColumnsFilterable

OptFull:

OptFull

FieldsOrColumns:

FieldsOrColumns

ShowTableAliasOpt:

ShowTableAliasOpt

FromOrIn:

FromOrIn

TableName:

TableName

ShowDatabaseNameOpt:

ShowDatabaseNameOpt

DBName:

DBName

ShowLikeOrWhereOpt:

ShowLikeOrWhereOpt

示例

create view v1 as select 1;
Query OK, 0 rows affected (0.11 sec)
show columns from v1;
+-------+-----------+------+------+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-----------+------+------+---------+-------+ | 1 | bigint(1) | YES | | NULL | | +-------+-----------+------+------+---------+-------+ 1 row in set (0.00 sec)
desc v1;
+-------+-----------+------+------+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-----------+------+------+---------+-------+ | 1 | bigint(1) | YES | | NULL | | +-------+-----------+------+------+---------+-------+ 1 row in set (0.00 sec)
describe v1;
+-------+-----------+------+------+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-----------+------+------+---------+-------+ | 1 | bigint(1) | YES | | NULL | | +-------+-----------+------+------+---------+-------+ 1 row in set (0.00 sec)
explain v1;
+-------+-----------+------+------+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-----------+------+------+---------+-------+ | 1 | bigint(1) | YES | | NULL | | +-------+-----------+------+------+---------+-------+ 1 row in set (0.00 sec)
show fields from v1;
+-------+-----------+------+------+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-----------+------+------+---------+-------+ | 1 | bigint(1) | YES | | NULL | | +-------+-----------+------+------+---------+-------+ 1 row in set (0.00 sec)
show full columns from v1;
+-------+-----------+-----------+------+------+---------+-------+---------------------------------+---------+ | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment | +-------+-----------+-----------+------+------+---------+-------+---------------------------------+---------+ | 1 | bigint(1) | NULL | YES | | NULL | | select,insert,update,references | | +-------+-----------+-----------+------+------+---------+-------+---------------------------------+---------+ 1 row in set (0.00 sec)
show full columns from mysql.user;
+------------------------+---------------+-------------+------+------+---------+-------+---------------------------------+---------+ | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment | +------------------------+---------------+-------------+------+------+---------+-------+---------------------------------+---------+ | Host | char(255) | utf8mb4_bin | NO | PRI | NULL | | select,insert,update,references | | | User | char(32) | utf8mb4_bin | NO | PRI | NULL | | select,insert,update,references | | | authentication_string | text | utf8mb4_bin | YES | | NULL | | select,insert,update,references | | | plugin | char(64) | utf8mb4_bin | YES | | NULL | | select,insert,update,references | | | Select_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Insert_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Update_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Delete_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Create_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Drop_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Process_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Grant_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | References_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Alter_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Show_db_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Super_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Create_tmp_table_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Lock_tables_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Execute_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Create_view_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Show_view_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Create_routine_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Alter_routine_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Index_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Create_user_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Event_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Repl_slave_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Repl_client_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Trigger_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Create_role_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Drop_role_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Account_locked | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Shutdown_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Reload_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | FILE_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Config_priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | Create_Tablespace_Priv | enum('N','Y') | utf8mb4_bin | NO | | N | | select,insert,update,references | | | User_attributes | json | NULL | YES | | NULL | | select,insert,update,references | | +------------------------+---------------+-------------+------+------+---------+-------+---------------------------------+---------+ 38 rows in set (0.00 sec)

MySQL 兼容性

SHOW [FULL] COLUMNS FROM 语句与 MySQL 完全兼容。如发现任何兼容性差异,请尝试 TiDB 支持资源

另请参阅