## mark a section (Learn more)

mysql> SHOW TABLE STATUS LIKE 'worldcities'; +-------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+ | 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 | +-------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+ | worldcities | InnoDB | 10 | Compact | 2731385 | 63 | 174800896 | 0 | 0 | 0 | NULL | 2007-06-12 18:28:04 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 120832 kB | +-------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+ mysql> SHOW TABLE STATUS LIKE 'regions_fips'; +--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+ | 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 | +--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+ | regions_fips | InnoDB | 10 | Compact | 4417 | 48 | 212992 | 0 | 0 | 0 | NULL | 2007-06-12 18:28:04 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 120832 kB | +--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+ mysql> SHOW TABLE STATUS LIKE 'places'; +--------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+ | 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 | +--------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+ | places | InnoDB | 10 | Compact | 238174 | 59 | 14172160 | 0 | 0 | 0 | 252808 | 2007-05-10 22:03:25 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 120832 kB | +--------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+

This paste will be private.