mysql查询表的详细信息_mysql 查看表详细信息

查看建表语句

show create table ${table_name}

mysql> show create table user;

+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Table | Create Table |

+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| user | CREATE TABLE `user` (

`id` bigint(64) NOT NULL,

`biz_account_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT 'BIZID',

`access_key` varchar(20) COLLATE utf8mb4_bin NOT NULL,

`access_secret` varchar(32) COLLATE utf8mb4_bin NOT NULL,

`api_invoke_times` int(8) NOT NULL DEFAULT '0' COMMENT 'API invoke',

`api_total_times` int(8) NOT NULL DEFAULT '0' COMMENT 'API total',

`created_at` datetime DEFAULT CURRENT_TIMESTAMP,

`updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (`id`) USING BTREE,

UNIQUE KEY `uq_biz_id` (`biz_account_id`) USING HASH,

UNIQUE KEY `uq_access_key_secret` (`access_key`,`access_secret`) USING BTREE

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin |

+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.01 sec)

查看字段信息

desc ${table_name}

mysql> desc user;

+------------------+-------------+------+-----+-------------------+-----------------------------+

| Field | Type | Null | Key | Default | Extra |

+------------------+-------------+------+-----+-------------------+-----------------------------+

| id | bigint(64) | NO | PRI | NULL | |

| biz_account_id | varchar(64) | NO | UNI | NULL | |

| access_key | varchar(20) | NO | MUL | NULL | |

| access_secret | varchar(32) | NO | | NULL | |

| api_invoke_times | int(8) | NO | | 0 | |

| api_total_times | int(8) | NO | | 0 | |

| created_at | datetime | YES | | CURRENT_TIMESTAMP | |

| updated_at | datetime | YES | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |

+------------------+-------------+------+-----+-------------------+-----------------------------+

8 rows in set (0.01 sec)