查看mysql 数据库表概要
指令： show table status from mysql \G
结果如下：
*************************** 1. row ***************************
Name: columns_priv
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 227994731135631359
Index_length: 1024
Data_free: 0
Auto_increment: NULL
Create_time: 2009-08-24 20:36:19
Update_time: 2009-08-24 20:36:19
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment: Column privileges
*************************** 2. row ***************************
Name: db
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 4
Avg_row_length: 438
Data_length: 1752
Max_data_length: 123286039799267327
Index_length: 4096
Data_free: 0
Auto_increment: NULL
Create_time: 2009-08-24 20:36:19
Update_time: 2009-08-26 16:15:29
Check_time: 2009-08-24 20:36:19
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment: Database privileges
。。。。
阅读(972) | 评论(0) | 转发(0) |
