查看mysql数据库表大小和最后修改时间_MySQL
- WBOYOriginal
- 2016-06-01 13:32:051180browse
bitsCN.com
查看mysql数据库表大小和最后修改时间
查看mysql数据库表相关信息如表大小、修改更新等信息，可以通过以下方式：
一
show table status like ’table_name‘ ;
二 在infortmation_schema下有表table ，存储了表相关信息，也可以通过此表来查询。
select * from information_schema.table where table_name ='table_name' ;
bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MYSQL的date_format以及STR_TO_DATE_MySQLNext article：mysql5.2.20 start service和apply security settings错误解决_MySQL