To add an index in your phpmyadmin the attached images will help to explain it.
Load the page which displays all the tables. See part of this page in PhpMyAdmin 2001.jpg
Notice that each table has a Properties column. Choose your table and click Properties in that row. See PhpMyAdmin 9001s.jpg for the Post table.
Notice that each property has an Index column. You can also see a table at the bottom which shows existing indexes. You don't want to create one if it already exists. Choose your property and click Index in that row.
See PhpMyAdmin 11001.jpg that shows a message to say the index has been added.
See PhpMyAdmin 12001.jpg that shows that the property "dateline" has been added to the list of indexes.
Hope this helps make sense of it all.
|