How do I check if an index exists on a table field in MySQL?

mysql indexing
Sean picture Sean · Sep 24, 2008 · Viewed 99.2k times · Source

I've needed to Google this a couple times, so I'm sharing my Q/A.

Answer

Sean picture Sean · Sep 24, 2008

Use SHOW INDEX like so:

SHOW INDEX FROM [tablename]

Docs: https://dev.mysql.com/doc/refman/5.0/en/show-index.html

Related questions

How do I add indices to MySQL tables?

I've got a very large MySQL table with about 150,000 rows of data. Currently, when I try and run SELECT * FROM table WHERE id = '1'; the code runs fine as the ID field is the primary index. However, for a …

Read More
How to see indexes for a database or table in MySQL?

How do I see if my database has any indexes on it? How about for a specific table?

Read More
Differences between INDEX, PRIMARY, UNIQUE, FULLTEXT in MySQL?

What are the differences between PRIMARY, UNIQUE, INDEX and FULLTEXT when creating MySQL tables? How would I use them?

Read More