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.

Table 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.

These comments will ...

Get Mastering phpMyAdmin 3.4 for Effective MySQL Management now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.