What is the function of row_format in Mysql

This article is to share with you about the role of row_format in Mysql, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Row_format of Mysql

If there are no varchar, text and their metamorphosis, blob and metamorphosis fields in a table, then the table is actually called a static table, that is, the row_format of the table is fixed, which means that each record occupies the same number of bytes. It has the advantages of fast reading and the disadvantage of wasting extra space.

Www.2cto.com

If there are varchar, text and their metamorphosis, blob and their metamorphosis fields in a table, then the table is actually called a dynamic table, that is, the row_format of the table is dynamic, that is, the bytes occupied by each record are dynamic. It has the advantage of saving space and the disadvantage of increasing the time cost of reading.

Therefore, tables with a large amount of search queries generally exchange space for time and are designed as static tables.

There are other values for row_format:

DEFAULT

FIXED

DYNAMIC

COMPRESSED

REDUNDANT

COMPACT

Www.2cto.com

Modify row format

ALTER TABLE table_name ROW_FORMAT = DEFAULT

The modification process results in:

Fixed--- > dynamic: this causes CHAR to become VARCHAR

Dynamic--- > fixed: this causes VARCHAR to become CHAR

This is what the role of row_format in Mysql is, and the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.