Can I know about existing indexes / keys in my table? I would be wonder if there is any command to get an existing index in the MySQL table.
Answer No: 179
To view the keys or indexes on a table, MySQL provides the SHOW KEYS and SHOW INDEXES commands. You can use any of these commands. The result of both commands is the same. Take the following examples: