Seeing indexes in a MySQL table - Geeks Worldwide


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.	Tags mysql, database, optimization, keys, index, Popular Searches linux, php, mysql, ubuntu, mysql mysql, tools, install mysql, gearman, source code, java more>>
Comments (write a comment): 0 comments so far. Be the first one to leave a comment on this article. Comment Name:* Email(not published):* Website (optional): Comment:* Notify me of followup comments via e-mail Similar Tutorials: How to find all tables of a particular storage engine in MySQL MySQL Performance Optimization Part II MySQL query to find all views in a database Not-so-well-known differences between MyISAM and Innodb MySQL server storage engines How to find if MySQL supports partitioning or not Tutorials in 'Database Management Systems > MySQL' (more): MySQL DATE_FORMAT function and ORDER BY MySQL Query Cache not necessarily a bad thing Download all Aspersa MySQL tools/scripts through a single command Download all maatkit scripts through a single command MySQL error while dropping databases Recent Tutorials: MySQL DATE_FORMAT function and ORDER BY MySQL Query Cache not necessarily a bad thing Download all Aspersa MySQL tools/scripts through a single command Download all maatkit scripts through a single command How to make class diagrams using Composition