MySQL获取表格信息

最新推荐文章于 2025-04-16 17:43:48 发布

最新推荐文章于 2025-04-16 17:43:48 发布 · 174 阅读

文章标签：

#数据库

本文介绍如何使用MySQL命令查询数据库中所有表格的状态信息，包括表格名称、引擎类型、创建时间等详细属性。

MySQL获取表格信息

mysql> use test;
Database changed
mysql> show table status;
+---------------+--------+---------+------------+------+----------------+-------
------+-----------------+--------------+-----------+----------------+-----------
----------+-------------+------------+-----------------+----------+-------------
---+---------+
| Name          | Engine | Version | Row_format | Rows | Avg_row_length | Data_l
ength | Max_data_length | Index_length | Data_free | Auto_increment | Create_tim
e         | Update_time | Check_time | Collation       | Checksum | Create_optio
ns | Comment |
+---------------+--------+---------+------------+------+----------------+-------
------+-----------------+--------------+-----------+----------------+-----------
----------+-------------+------------+-----------------+----------+-------------
---+---------+
| emp           | InnoDB |      10 | Compact    |    0 |              0 |
16384 |               0 |            0 |         0 |           NULL | 2015-09-16
 16:18:06 | NULL        | NULL       | utf8_general_ci |     NULL |
   |         |
| stu_view      | NULL   |    NULL | NULL       | NULL |           NULL |
 NULL |            NULL |         NULL |      NULL |           NULL | NULL
          | NULL        | NULL       | NULL            |     NULL | NULL
   | VIEW    |
| t_depart_info | InnoDB |      10 | Compact    |    0 |              0 |
16384 |               0 |            0 |         0 |           NULL | 2015-08-23
 22:12:02 | NULL        | NULL       | utf8_general_ci |     NULL |
   |         |
| t_stu_info    | InnoDB |      10 | Compact    |    6 |           2730 |
16384 |               0 |            0 |         0 |              9 | 2015-08-23
 21:36:02 | NULL        | NULL       | utf8_general_ci |     NULL |
   |         |
| t_tea_info    | InnoDB |      10 | Compact    |    0 |              0 |
16384 |               0 |        16384 |         0 |              1 | 2015-08-23
 21:39:53 | NULL        | NULL       | utf8_general_ci |     NULL |
   |         |
+---------------+--------+---------+------------+------+----------------+-------
------+-----------------+--------------+-----------+----------------+-----------
----------+-------------+------------+-----------------+----------+-------------
---+---------+
5 rows in set (0.00 sec)

mysql>