How to check the size of a table in a specific MySQL database?

Just like we have checked the size of the MySQL database, we can also check the size of the tables in a specific database. It can be done as follows -

mysql> SELECT
    -> table_name AS "Table",
    -> round(((data_length + index_length) / 1024 / 1024), 2) as SIZE
    -> FROM information_schema.TABLES
    -> WHERE table_schema = "SAMPLE"
    -> ORDER BY SIZE;
+-------------+-------+
| Table       | SIZE  |
+-------------+-------+
| employee    | 0.02  |
| student     | 0.02  |
| new_student | 0.02  |
+-------------+-------+
3 rows in set (0.00 sec)

The output here gives the Example size of the three tables in the database.

The above is the detailed content of How to check the size of a table in a specific MySQL database?. For more information, please follow other related articles on the PHP Chinese website!