MySQL Forums
Forum List  »  Perl

Using DBI for MySQL metadata
Posted by: CHap Harrison
Date: February 17, 2013 01:47PM

I'm unable to get the information I need from reading the CPAN DBI documentation, and it was suggested I post here for help specifically for MySQL. (FYI I'm using Perl 5.10 and MySQL 5.5/5.6).

I can't seem to find a list of descriptions of the info that's being returned from this:

my $sth_column_info = $dbh->column_info( $catalog, $schema, $table, undef );
my $aoa_ref = $sth_column_info->fetchall_arrayref;

There are 30-some elements in the array for each column. The meaning of some is obvious, the meaning of others is not.

It's also not clear to me how to express the arguments to fetchall_arrayref() to ask for only certain information.

And there are some numeric codes that aren't meaningful without a key.

Is there some documentation, specifically aimed at MySQL, on how to use the DBI for obtaining metadata?

Options: ReplyQuote

Written By
Using DBI for MySQL metadata
February 17, 2013 01:47PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.