Database Reference
In-Depth Information
We click the Edit link (small pencil) on the line containing the author_id index; this
shows the current state of this index. The interface has room to add another field
to this index. We could use the Add to index 1 column(s) feature should we need
to add more than one field. In the field selector, we select language . This time we
do not have to enter a size, as the whole field will be used in the index. For better
documentation, we change the Index name ( author_language is appropriate).
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 fulltext searches. It is supported only on MyISAM
tables for the VARCHAR and TEXT fields. We can use the Fulltext quick link
in the fields list or go to the index management panel and choose Fulltext in the
drop-down menu.
We add a FULLTEXT index on the description field, so that we are able to locate
a book from words present in its description.
 
Search WWH ::




Custom Search