#### 查看 ~~~ show keys from 表名; ~~~ 结果 ~~~ *************************** 1. row *************************** Table: t1 Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: id Collation: A Cardinality: 1 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: Index_comment: *************************** 2. row *************************** Table: t1 Non_unique: 0 Key_name: name Seq_in_index: 1 Column_name: name Collation: A Cardinality: 1 Sub_part: NULL Packed: NULL Null: YES Index_type: BTREE Comment: Index_comment: *************************** 3. row *************************** Table: t1 Non_unique: 1 Key_name: age Seq_in_index: 1 Column_name: age Collation: A Cardinality: 1 Sub_part: NULL Packed: NULL Null: YES Index_type: BTREE Comment: Index_comment: *************************** 4. row *************************** Table: t1 Non_unique: 1 Key_name: name_2 Seq_in_index: 1 Column_name: name Collation: A Cardinality: 1 Sub_part: NULL Packed: NULL Null: YES Index_type: BTREE Comment: Index_comment: *************************** 5. row *************************** Table: t1 Non_unique: 1 Key_name: name_2 Seq_in_index: 2 Column_name: age Collation: A Cardinality: 1 Sub_part: NULL Packed: NULL Null: YES Index_type: BTREE Comment: Index_comment: *************************** 6. row *************************** Table: t1 Non_unique: 1 Key_name: intro Seq_in_index: 1 Column_name: intro Collation: NULL Cardinality: 1 Sub_part: NULL Packed: NULL Null: YES Index_type: FULLTEXT Comment: Index_comment: 6 rows in set (0.00 sec) ~~~