Changing Data and Structure - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 103

• Setting a non-unique Index or a Unique index on a column
• Setting a FULLTEXT index (offered only if the column type allows it)
These are quick links that may be useful in some situations, but they do not replace
the full index management panel. Both of these are explained in this chapter.
We can use the checkboxes to choose columns. Then, with the appropriate With
selected icons, we can edit the columns with Change or do a multiple column
deletion with Drop . The Check All / Uncheck All option permits us to easily check
or uncheck all boxes.
TEXT column type
We will now explore how to use the TEXT column type and the relevant
configuration values to adjust for the best possible phpMyAdmin behavior. First, we
add to the book table a TEXT column called description .
There are three configuration directives that control the layout of the text area that
will be displayed in Insert or Edit mode for the TEXT column type. The number of
display columns and rows for each column is defined by:
$cfg['TextareaCols'] = 40;
$cfg['TextareaRows'] = 15;
This gives (by default) space to work on a TEXT column type as shown in the
following screenshot:
The settings impose only a visual limit on the text area, and a vertical scroll bar is
created by the browser if necessary.