Databases Reference
In-Depth Information
Changing table attributes
Table attributes are the various properties of a table. This section discusses the
settings for some of them.
Table storage engine
The first attribute we can change is called
Storage
Engine
.
This controls the whole behavior of the tableāits location (on disk or in memory),
the index structure, and whether it supports transactions and foreign keys. The drop-
down list varies depending on the storage engines supported by our MySQL server.
Changing a table's storage engine may be a long operation if
the number of rows is large.
Table comments
Table
comments
option allows us to enter comments for the table.
Search WWH ::
Custom Search