List:MySQL and Perl« Previous MessageNext Message »
From:Paul Sharpe Date:April 13 1999 10:02pm
Subject:Re: Way to read indexes?
View as plain text  
On Tue, 13 Apr 1999, Joe Junkin wrote:

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

You could use

  SHOW INDEX FROM foo

(See the Mysql manual)

Paul

Thread
Way to read indexes?Joe Junkin14 Apr
  • Re: Way to read indexes?Paul Sharpe14 Apr
  • Way to read indexes?Michael Widenius14 Apr