`information_schema.statistics.index_comment`

mysql

type: VARCHAR NOT NULL

5.7-8

type: VARCHAR NOT NULL

10.2-10.7

type: VARCHAR(1024) NULL

Note:

Any comment with comment attribute provided for the index when creating the index.

4-6.1