Perl object for representing and querying a mySQL table definition -

Perl object for representing and querying a mySQL table definition -

i don't know want, certainly has had same need, , has solved in far improve manner could:

i'm looking mechanism extract info definition of mysql table database , allow queried list of columns , definitions, part of routine dynamically build dml? have table parameters (e.g. engine, index, etc.) available, too.

our databases aren't particularly advanced, , don't have encyclopedic knowledge of sql ddl, came wouldn't of much utilize else. there out there in perl - preferably object-oriented - this, @ to the lowest degree mysql?

the dbi interface has set of "catalog methods": http://metacpan.org/pod/dbi#catalog-methods.

there similar stackoverflow question can at: how schemas perl's dbi?

mysql perl ddl