How can you see field comments from mysql client?
show full columns from <table_name>
This is the output:
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment
I hope this is useful for you
This query will give you much more information than the describe
statement:
SELECT *
FROM information_schema.columns
WHERE table_name = 'metrics'
AND table_schema = '...' -- Optionally, filter the schema as well, to avoid conflicts