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