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

Multi-column indexes and index editing
In the next example, we assume that in a future application we will need to find the
topics written by a speciic author in a speciic language. It makes sense to expand
our author_id index, adding the language column to it.
We click on the Edit link (small-pencil icon) on the line containing the author_id
index; this shows the current state of this index. The interface has room to add
another column to this index. We could use the Add to index 1 column(s) feature
should we need to add more than one column. In the selector, we pick language .
This time we do not have to enter a size, as the whole column will be used in the
index. For better documentation, we change the Index name ( author_language is
appropriate) as shown in the following screenshot:
We save this index modification. In the list of indexes, we can confirm our
index modification.
FULLTEXT indexes
This special type of index allows for full text searches. It is supported only on
MyISAM tables for the VARCHAR and TEXT column types, but MySQL 5.6 should
be offering this feature for InnoDB too. We can use the Add FULLTEXT index link in
the columns list or go to the index management panel and choose FULLTEXT in the
drop-down menu.