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";
Get MySQL and mSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.