Seeing indexes in a MySQL table
To show indexes on a MySQL table use any of the following commands in a MySQL client:
SHOW INDEX FROM table_name or SHOW INDEX IN table_name
SHOW INDEXES FROM table_name or SHOW INDEXES IN table_name
SHOW KEYS FROM table_name or SHOW KEYS IN table_name
Replace table_name with the actual table name. You can optionally append the following clause at the end of any query above to select the database to use.
FROM db_name or IN db_name
Replace db_name with the database name.
Please feel free to use the comments form below if you have any questions or need more explanation on anything. Use the icons below to share this tutorial with your friends.
tags cloud
popular searches
free download for mysql database server 5.1.5, php, linux, mysql mysql, mysql, java, install mysql, gearman, ubuntu, tools, source code, bison, mysql initialization, install cairo, laptop
Similar Tutorials:
- SQL: Union and Union All
- Is MySQL 5.6 slower than MySQL 5.5? No, it's faster
- MySQL Query Cache not necessarily a bad thing
- MySQL table_cache, information_schema, and open files limit
- How to install MySQL Gearman UDF on Ubuntu/Debian Linux
Tutorials in 'Database Management Systems > MySQL' (more):
- Is MySQL 5.6 slower than MySQL 5.5? No, it's faster
- Download, configure, compile, and install MySQL 5.6
- Fast, parallel restore from SQL dumps (mysqldump) for MySQL
- How to download and install MySQL on Mac OS X
- MySQL DATE_FORMAT function and ORDER BY
Comments (write a comment):
0 comments so far. Be the first one to leave a comment on this article.