3 messages in com.mysql.lists.perlWay to read indexes?
FromSent OnAttachments
Joe Junkin13 Apr 1999 10:09 
Paul Sharpe13 Apr 1999 15:02 
Michael Widenius13 Apr 1999 17:30 
Subject:Way to read indexes?
From:Michael Widenius (mon@monty.pp.sci.fi)
Date:04/13/1999 05:30:08 PM
List:com.mysql.lists.perl

"Joe" == Joe Junkin <jjun@datacrawler.com> writes:

Joe> Hi all. Joe> I am desperately looking for a way to read the mysql indexes from DBI. I
can see Joe> that msql has a function for ListIndex, but it is not for MySQL. Is
ListIndex on Joe> the module agenda? If not, how can I get this information from within Perl? Joe> I have an administrative interface into mysql and need to be able to
read/edit Joe> all of the indexes for a table.

Hi!

In MySQL you can do almost anything with SQL commands (as opposite to mSQL where you have different interfaces)

Try:

SHOW INDEX from table_name

Regards, Monty