Shulou(Shulou.com)05/31 Report--

This article shows you how to view the number of records of all tables in mysql. The content is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Record the number of records that view all tables in mysql:

TABLE_SCHEMA: database name

TABLE_NAME: table name

ENGINE: storage engine used

TABLES_ROWS: number of records

DATA_LENGTH: the result of the data size is in bytes, except 1024 for K and 1048576 (= 1024 to 1024) for M.

INDEX_LENGTH: index size

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 and 1048576 (= 1024024) for M.

The above is how to view the number of records of all tables in mysql. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.