Mastering phpMyAdmin 3.4 for Effective MySQL Management

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.

Note

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.

These comments will ...