List:MySQL and Perl« Previous MessageNext Message »
From:Michael Widenius Date:April 14 1999 12:30am
Subject:Way to read indexes?
View as plain text  
>>>>> "Joe" == Joe Junkin <jjunkin@stripped> 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
Thread
Way to read indexes?Joe Junkin14 Apr
  • Re: Way to read indexes?Paul Sharpe14 Apr
  • Way to read indexes?Michael Widenius14 Apr