Static and Dynamic table in mysql
http://dev.mysql.com/doc/mysql/en/Static_format.html
http://dev.mysql.com/doc/mysql/en/Dynamic_format.html
Static format is the default for MyISAM tables. It is used when the table contains no variable-length columns (VARCHAR, BLOB, or TEXT). Each row is stored using a fixed number of bytes.
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC option.
http://dev.mysql.com/doc/mysql/en/Static_format.html
http://dev.mysql.com/doc/mysql/en/Dynamic_format.html
Static format is the default for MyISAM tables. It is used when the table contains no variable-length columns (VARCHAR, BLOB, or TEXT). Each row is stored using a fixed number of bytes.
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC option.
2 Comments:
xiaoming,
I was looking at your blog post
about linux web host .
You can now place a link to
your website on our website for free. See:
http://www.thefreeadforum.com
We get over 18,000 visitors per day.
Many search under linux web host .
We have a special category for linux web host
in our search engine friendly directory.
Your listing will be spidered by the search
engines under linux web host .
We hope you find this to be a
good opportunity for some free
advertising.
Good luck,
John,
http://www.thefreeadforum.com
The Free Advertising Forum..
Web directory
Post a Comment
<< Home