Subject: Getting index metadata with LISTINDEX
Date: Wed, 28 Apr 1999 16:35:49 -0500
From: "Moroney, Dennis" <Moro...@zeus.dt.uh.edu>
To: "'msql...@lists.mysql.com'"
<msql...@lists.mysql.com>
I would like to use the documented SQL extension named LISTINDEX get the
table index by performing the following:
$sth = $dbh->prepare( qq[LISTINDEX $table $index] );
$sth->execute;
$idx = $sth->{????};
The msqlListIndex function returns a result table. Thus you don't
have to look at the sth attributes (besides NUM_OF_FIELDS, NAME and
TYPE), but use $sth->fetchrow_hashref() or something similar to
retrieve the information.
Bye,
Jochen
1 message in com.mysql.lists.perlRe: Getting index metadata with LISTI...
