Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Get a List of Indexes of an Existing Table
How To Get a List of Indexes of an Existing Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements
✍: 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.
2007-05-11, 4875👍, 0💬
Popular Posts:
What are the different accessibility levels defined in .NET ? Following are the five levels of acces...
Which is the best place to store ConnectionString in Dot Net Projects? I am about to deploy my first...
1. What is normalization. 2. Difference between procedure and functions. 3. Oracle 9i Vs 10g. 4. how...
Wha is the output from System.out.println("Hell o"+null);?Hellonull
What is effort variance? Effort Variance = (Actual effort – Estimated Effort) / Estimated Effort.