The Options subtab enables you to set several types of options. The next figure shows an example of this tab.
Table options are grouped into the following sections:
Merge Table Options
The following sections describe these options in more detail.
In the General Options section, choose a pack
keys option. The options are
Pack None, and
Pack All. You
may also encrypt the definition of a table. The
AUTO_INCREMENT and delayed key update behaviors
apply only to
To set the row format, choose the desired row format from the list. For more information about the different row formats that are available, see MyISAM Table Storage Formats.
These options are:
When you expect a table to be particularly large, use the Avg. Row, Min. Rows, and Max. Rows options to enable the MySQL server to better accommodate your data. See CREATE TABLE Statement for more information on how to use these options.
Storage Options section is available only
MyISAM tables. Use it to configure a custom
path to the table storage and data files. This can help improve
server performance by locating different tables on different hard
Merge Table Options section to
MERGE tables. To create a
MERGE table, select
your storage engine and then specify the
tables you wish to merge in the Union Tables
You may specify the action the server should take when users
attempt to perform
INSERT statements on the
merge table. You may also select the
Method by selecting from the list. For more information
MERGE tables, see
The MERGE Storage Engine.