我希望看到个别领域的评论。通常情况下,我希望从"describe“参数中获得一些东西。
mysql> describe metrics;
+-------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| ty | int(10) unsigned | NO | | NULL | |
| t | bigint(20) unsigned | NO | | NULL | |
| s | int(10) unsigned | NO | | 60000 | |
| e | int(10) unsigned | NO | | NULL | |
| c | int(10) unsigned | NO | | NULL | |
+-------+---------------------+------+-----+---------+----------------+发布于 2012-10-02 17:04:46
show full columns from <table_name>这是输出:
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment我希望这对你有用
发布于 2011-10-20 19:16:53
此查询将提供比describe语句多得多的信息:
SELECT *
FROM information_schema.columns
WHERE table_name = 'metrics'
AND table_schema = '...' -- Optionally, filter the schema as well, to avoid conflicts发布于 2017-03-03 12:01:07
你总是可以使用:
show create table <tablename>https://stackoverflow.com/questions/7835092
复制相似问题