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

Under the information_schema of 1.mysql, there is a data dictionary table that stores the basic information of the database. You can query the tables table to get the table-related information you need. Mysql > show databases

2. Use information_schema

3. Show tables

4. Desc tables

5 select table_name,table_rows from tables order by table_rows desc limi 10

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.