mysql查询命令

SHOW DATABASES;#查询数据库
mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| database_name      |
| example_database   |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
6 rows in set (0.00 sec)

SHOW TABLE STATUS  FROM database_name; 显示数据库 database_name中所有表的信息
mysql>SHOW TABLE STATUS  FROM database_name;
+---------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+
| Name          | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time | Check_time | Collation          | Checksum | Create_options | Comment |
+---------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+
| example_table | InnoDB |      10 | Dynamic    |    3 |           5461 |       16384 |               0 |            0 |         0 |              4 | 2024-03-14 16:25:30 | NULL        | NULL       | utf8mb4_0900_ai_ci |     NULL |                |         |
| table_name    | InnoDB |      10 | Dynamic    |    0 |              0 |       16384 |               0 |            0 |         0 |           NULL | 2024-03-14 16:02:12 | NULL        | NULL       | utf8mb4_0900_ai_ci |     NULL |                |         |
+---------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+
2 rows in set (0.10 sec)

SHOW TABLE STATUS  FROM database_name LIKE 'example%'\G;# 加上 \G，查询结果按列打印
mysql>SHOW TABLE STATUS  FROM database_name LIKE 'example%'\G;
*************************** 1. row ***************************
           Name: example_table
         Engine: InnoDB
        Version: 10
     Row_format: Dynamic
           Rows: 3
 Avg_row_length: 5461
    Data_length: 16384
Max_data_length: 0
   Index_length: 0
      Data_free: 0
 Auto_increment: 4
    Create_time: 2024-03-14 16:25:30
    Update_time: NULL
     Check_time: NULL
      Collation: utf8mb4_0900_ai_ci
       Checksum: NULL
 Create_options: 
        Comment: 
1 row in set (0.01 sec)