Count the size of a MySQL DATA table

How can I query the size of each table in the MySQL database?

MySQL has a database named information_schema, which has a TABLES Table. The main fields of this table are:

TABLE_SCHEMA: Database Name
TABLE_NAME: Table Name
ENGINE: The storage ENGINE used
TABLES_ROWS: number of records
DATA_LENGTH: data size
INDEX_LENGTH: Index size

For other fields, see the MySQL manual.

Use information_schema; SELECT TABLE_NAME, (DATA_LENGTH/1024/1024) as DataM, (INDEX_LENGTH/1024/1024) as IndexM, (DATA_LENGTH + INDEX_LENGTH)/1024/1024) as AllM, TABLE_ROWSFROM TABLESWHERE TABLE_SCHEMA = 'db _ ip ';