留空
行存储格式
1.固定格式
2.动态格式
3.压缩格式
1.查看行存储格式
mysql> show table status like 't' \G;
*************************** 1. row ***************************
Name: t
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 3
Avg_row_length: 15
Data_length: 45
Max_data_length: 4222124650659839
Index_length: 1024
Data_free: 0
Auto_increment: NULL
Create_time: 2011-08-05 19:07:26
Update_time: 2011-08-05 19:22:22
Check_time: NULL
Collation: latin1_swedish_ci
Checksum: NULL
Create_options:
Comment:
1 row in set (0.00 sec)
ERROR:
No query specified
mysql>
阅读(821) | 评论(0) | 转发(0) |