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, 1541🔥, 0💬
Popular Posts:
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...