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, 4664👍, 0💬
Popular Posts:
WHat will be the result of the following code? #define TRUE 0 // some code while (TRUE) { // some co...
How To Test Transaction Isolation Levels? - MySQL FAQs - Transaction Management: Commit or Rollback ...
How can we know the number of days between two given dates in PHP? Simple arithmetic: <?php $...
Can Sub Procedure/Function Be Called Recursively? - Oracle DBA FAQ - Creating Your Own PL/SQL Proced...
Does .NET support UNICODE and how do you know it supports? Yes .NET definitely supports UNICODE. Try...