Support Center > Knowledgebase > phpMyAdmin > When I create a table, I click the Index checkbox for 2 fields and phpMyAdmin generates only one index with those 2 fields.
When I create a table, I click the Index checkbox for 2 fields and phpMyAdmin generates only one index with those 2 fields.
In phpMyAdmin 2.2.0 and 2.2.1, this is the way to create a multi-fields index. If you want two indexes, create the first one when creating the table, save, then display the table properties and click the Index link to create the other index.
Also Read