Mysql views the number of records in all tables

In mysql, you can view the number of records of all tables. in mysql, you can view the number of records of all tables: TABLE_SCHEMA: Database Name TABLE_NAME: Table Name ENGINE: Used storage ENGINE TABLES_ROWS: number of records DATA_LENGTH: the data size is measured in bytes, excluding 1024 as K and 1048576 (= 1024*1024) as M INDEX_LENGTH: Index size www.2cto.com use information_schema; select table_schema, table_name, table_rows from tables order by table_rows desc; view the specified database size: SELECT sum (DATA_LENGTH) + sum (INDEX_LENGTH) FROM information_schema.TABLES where TABLE_SCHEMA = 'database name '; the result is in bytes. Except 1024 for K, except 1048576 (= 1024*1024) for M.