Shulou(Shulou.com)06/01 Report--

How many records are there in each table queried by mysql? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

Mysql queries how many records there are in each table: execute the [select table_name,table_rows from tables where TABLE_SCHEMA = 'name of the database';] statement.

Mysql's method of querying how many records there are in each table

Execute the following SQL statement:

Use information_schema;select table_name,table_rows from tables where TABLE_SCHEMA = 'name of the database' order by table_rows desc; thank you for reading! After reading the above, do you have a general idea of mysql's method of querying how many records are in each table? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, 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.