MySQL and mSQL

Name

Msql::Statement::listindices

Synopsis

@indices = $statement_handle->listindices;

Msql::Statement::listindices returns the indices associated with any of the fields found in the statement handle. Because the function looks for field names directly, it is useful only with names returned from Msql::listfields. If no indices are found, an undefined value undef is returned. This function can only be used with mSQL 2.0, or greater, database servers.

Example

use Msql;
my $db = Msql->connect;
$db->selectdb('mydata');
my $mytable_fields = $db->listfields('mytable');

my @indices = $mytable_fields->listindices;
print "'mytable' contains these indices: " . join(", ",@indices) . "\n";