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, 4619👍, 0💬
Popular Posts:
How To Merge Values of Two Arrays into a Single Array? - PHP Script Tips - PHP Built-in Functions fo...
How To Join a List of Keys with a List of Values into an Array? - PHP Script Tips - PHP Built-in Fun...
What is the version information in XML? “version” tag shows which version of XML is used.
What Tools to Use to View HTML Documents? The basic tool you need to view HTML documents is any Web ...
.NET INTERVIEW QUESTIONS - What is the difference between System exceptions and Application exceptio...