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.
Did this tutorial help a little? How about buy me a cup of coffee?
Please feel free to use the comments form below if you have any questions or need more explanation on anything. I do not guarantee a response.
IMPORTANT: You must thoroughy test any instructions on a production-like test environment first before trying anything on production systems. And, make sure it is tested for security, privacy, and safety. See our terms here.
tags cloud
popular searches
free download for mysql database server 5.1.5, bison, gearman, install cairo, php, java, source code, linux, laptop, install mysql, mysql mysql, mysql, mysql initialization, tools, ubuntu
Similar Tutorials:
- How to set default values for MySQL JSON columns
- MySQL DATE_FORMAT function and ORDER BY
- Install MySQL Server 5.0 and 5.1 from source code
- How to rename MySQL DB by moving tables
- What should be monitored on a busy Database/MysQL server?
Tutorials in 'Database Management Systems > MySQL' (more):
- What should be monitored on a busy Database/MysQL server?
- How to speed up a Mysql replica?
- The server requested authentication method unknown to the client [phpmyadmin]
- How to set default values for MySQL JSON columns
- How to delete rows in table when PK is referenced in another table
Comments (write a comment):
0 comments so far. Be the first one to leave a comment on this article.