m
How can you see field comments from mysql client?
获取MySql
表中字段的注释:
mysql> SELECT *
FROM information_schema.columns
WHERE table_name = 'metrics'
AND table_schema = '...' -- Optionally, filter the schema as well, to avoid conflicts
或者:
mysql> show full columns from <table_name>
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment