系统表介绍
INNODB_SYS_FIELDS 表提供了innodb 索引的元数据
| 列名 | 含义 |
|---|---|
| INDEX_ID | 索引ID |
| NAME | 索引名 |
| POS | 列在索引中的位置 |
实例
mysql> select * from information_schema.INNODB_SYS_FIELDS ;
+----------+--------------------+-----+
| INDEX_ID | NAME | POS |
+----------+--------------------+-----+
| 11 | ID | 0 |
| 12 | FOR_NAME | 0 |
| 13 | REF_NAME | 0 |
| 14 | ID | 0 |
| 14 | POS | 1 |
| 15 | SPACE | 0 |
| 16 | SPACE | 0 |
| 17 | TABLE_ID | 0 |
| 17 | POS | 1 |
| 17 | BASE_POS | 2 |
| 18 | name | 0 |
| 19 | Server_name | 0 |
| 20 | help_topic_id | 0 |
| 21 | name | 0 |
| 22 | help_category_id | 0 |
| 23 | name | 0 |
| 24 | help_keyword_id | 0 |
| 24 | help_topic_id | 1 |
| 25 | help_keyword_id | 0 |
| 26 | name | 0 |
| 27 | Name | 0 |
| 28 | Time_zone_id | 0 |
| 29 | Time_zone_id | 0 |
| 29 | Transition_time | 1 |
| 30 | Time_zone_id | 0 |
| 30 | Transition_type_id | 1 |
| 31 | Transition_time | 0 |
| 32 | database_name | 0 |
| 32 | table_name | 1 |
| 33 | database_name | 0 |
| 33 | table_name | 1 |
| 33 | index_name | 2 |
| 33 | stat_name | 3 |
| 34 | Channel_name | 0 |
| 35 | Channel_name | 0 |
| 36 | Channel_name | 0 |
| 36 | Id | 1 |
| 37 | source_uuid | 0 |
| 37 | interval_start | 1 |
| 38 | cost_name | 0 |
| 39 | cost_name | 0 |
| 39 | engine_name | 1 |
| 39 | device_type | 2 |
| 40 | variable | 0 |
| 41 | id | 0 |
| 42 | id | 0 |
| 75 | id | 0 |
| 76 | doc_id | 0 |
| 77 | doc_id | 0 |
| 78 | key | 0 |
| 79 | doc_id | 0 |
| 80 | doc_id | 0 |
| 81 | FTS_DOC_ID | 0 |
| 82 | title | 0 |
| 82 | body | 1 |
| 83 | word | 0 |
| 83 | first_doc_id | 1 |
| 84 | word | 0 |
| 84 | first_doc_id | 1 |
| 85 | word | 0 |
| 85 | first_doc_id | 1 |
| 86 | word | 0 |
| 86 | first_doc_id | 1 |
| 87 | word | 0 |
| 87 | first_doc_id | 1 |
| 88 | word | 0 |
| 88 | first_doc_id | 1 |
+----------+--------------------+-----+
67 rows in set (0.01 sec)