Core metadata for MySQL tables

of the Index

Mysql> Show Indexes fromrecordsinrangetest;+--------------------+------------+--------------+--------------+-------------+-----------+-------------+------ ----+--------+------+------------+---------+---------------+| Table | Non_unique | Key_name | Seq_in_index | column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |+--------------------+------------+--------------+--------------+-------------+-----------+----- --------+----------+--------+------+------------+---------+---------------+| Recordsinrangetest |0| PRIMARY |1| ID | A |24290| NULL |      NULL | |         BTREE |               | || Recordsinrangetest |1| Idx_name |1| name | A | A| NULL | NULL | YES |         BTREE |               | || Recordsinrangetest |1| Idx_age |1| Age | A | A| NULL | NULL | YES |         BTREE |               | || Recordsinrangetest |1| Idx_age_name |1| name | A | A| NULL | NULL | YES |         BTREE |               | || Recordsinrangetest |1| Idx_age_name |2| Age | A | A| NULL | NULL | YES |         BTREE |               | |+--------------------+------------+--------------+--------------+-------------+-----------+-------------+----- -----+--------+------+------------+---------+---------------+5Rowsinch Set(0.00Sec

of the table itself

+--------------------+--------+---------+------------+-------+----------------+-------------+-----------------+ --------------+-----------+----------------+---------------------+-------------+------------+------------------ -+----------+----------------+---------+| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | create_options | Comment |+--------------------+--------+---------+------------+-------+----------------+-------------+---------- -------+--------------+-----------+----------------+---------------------+-------------+------------+---------- ---------+----------+----------------+---------+| Recordsinrangetest | InnoDB |Ten| Compact |24290| $|1589248|0|1425408|4194304|28660|2018- .- the  the: in: -| NULL | NULL |     Latin1_swedish_ci |                NULL |         | |+--------------------+--------+---------+------------+-------+----------------+-------------+----------------- +--------------+-----------+----------------+---------------------+-------------+------------+----------------- --+----------+----------------+---------+

Core metadata for MySQL tables