Collections:
Show All Indexes of a given Table in MySQL
How To Get a List of Indexes of a Given Table in MySQL?
✍: FYIcenter.com
If you want to see the index you have just created for an existing table, you can use the "SHOW INDEX FROM tableName" command to get a list of all indexes in a given table. The tutorial script below shows you a nice example:
mysql> SHOW INDEX FROM TIP; +------------+-------------+--------------+-------------+... | Non_unique | Key_name | Seq_in_index | Column_name |... +------------+-------------+--------------+-------------+... | 0 | PRIMARY | 1 | id |... | 1 | tip_subject | 1 | subject |... +------------+-------------+--------------+-------------+... 2 rows in set (0.03 sec)
It's interesting to see that there is a default index for the primary key column.
⇒ Drop an Existing Index in MySQL
⇐ Create an Index for a Given Table in MySQL
2018-02-14, 1537🔥, 0💬
Popular Posts:
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...