次の [FULL] 列を表示

ステートメントSHOW [FULL] COLUMNS FROM <table_name>は、テーブルまたはビューの列を便利な表形式で記述します。オプションのキーワードFULLは、現在のユーザーがその列に対して持っている権限と、テーブル定義からのcommentを表示します。

ステートメントSHOW [FULL] FIELDS FROM <table_name>DESC <table_name>DESCRIBE <table_name> 、およびEXPLAIN <table_name>は、このステートメントの別名です。

ノート:

DESC TABLE <table_name>DESCRIBE TABLE <table_name> 、およびEXPLAIN TABLE <table_name>は、上記のステートメントと同等ではありません。それらはDESC SELECT * FROM &#x3C;table_name>の別名です。

あらすじ

表示ステートメント:

ShowStmt

ShowColumnsFilterable:

ShowColumnsFilterable

OptFull:

OptFull

フィールドまたは列:

FieldsOrColumns

ShowTableAliasOpt:

ShowTableAliasOpt

FromOrIn:

FromOrIn

テーブル名:

TableName

ShowDatabaseNameOpt:

ShowDatabaseNameOpt

DB名:

DBName

ShowLikeOrWhereOpt:

ShowLikeOrWhereOpt

mysql> create view v1 as select 1; Query OK, 0 rows affected (0.11 sec) mysql> show columns from v1; +-------+-----------+------+------+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-----------+------+------+---------+-------+ | 1 | bigint(1) | YES | | NULL | | +-------+-----------+------+------+---------+-------+ 1 row in set (0.00 sec) mysql> desc v1; +-------+-----------+------+------+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-----------+------+------+---------+-------+ | 1 | bigint(1) | YES | | NULL | | +-------+-----------+------+------+---------+-------+ 1 row in set (0.00 sec) mysql> describe v1; +-------+-----------+------+------+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-----------+------+------+---------+-------+ | 1 | bigint(1) | YES | | NULL | | +-------+-----------+------+------+---------+-------+ 1 row in set (0.00 sec) mysql> explain v1; +-------+-----------+------+------+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-----------+------+------+---------+-------+ | 1 | bigint(1) | YES | | NULL | | +-------+-----------+------+------+---------+-------+ 1 row in set (0.00 sec) mysql> show fields from v1; +-------+-----------+------+------+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-----------+------+------+---------+-------+ | 1 | bigint(1) | YES | | NULL | | +-------+-----------+------+------+---------+-------+ 1 row in set (0.00 sec) mysql> 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) mysql> show full columns from mysql.user; +-----------------------+---------------+-------------+------+------+---------+-------+---------------------------------+---------+ | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment | +-----------------------+---------------+-------------+------+------+---------+-------+---------------------------------+---------+ | Host | char(64) | 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 | | | 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 | | | 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 | | +-----------------------+---------------+-------------+------+------+---------+-------+---------------------------------+---------+ 33 rows in set (0.01 sec)

MySQL の互換性

このステートメントは、MySQL と完全に互換性があると理解されています。互換性の違いは、GitHub で問題を介して報告されたにする必要があります。

こちらもご覧ください