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

The following content mainly brings you mysql how to view the number of rows of tables in the database and sort them. The knowledge mentioned is slightly different from books, which are summed up by professional and technical personnel in the process of contact with users, and have certain experience sharing value. I hope to bring help to the majority of readers.

Mysql looks at the number of rows of all tables in the database and sorts them:

After a database migration or restore, you can check whether the data is correct by comparing the number of rows.

Mysql > use information_schema;mysql > select table_name,table_rows from tables where TABLE_SCHEMA= 'kpsumi' order by table_rows desc

For the above about mysql how to view the number of rows of tables in the database and sort them, if you need to know more, you can continue to pay attention to the innovation of our industry. If you need professional answers, you can contact the pre-sales and after-sales on the official website. I hope this article can bring you some knowledge updates.

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.