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

相关问答