perl mysql table_info method question.

perl mysql table_info method question.

am 05.01.2010 15:18:22 von Ollie Jones

I am planning to use PERL DBI to do data transfer operations between
Oracle (10g) and mySQL (5.1.41) table servers. I have the latest and
greatest CPAN bits.

I hope to control some aspects of these operations by storing tags in
table and column comments. For example I might put the string
--ANONYMIZE-- into a table comment if my data transfer operation needs
to randomize data from that particular table to sanitize it.

DBI offers some nicely designed database independent metadata access
methods, for example the table_info method. The trouble is, this
table_info method returns empty REMARK data for mySQL, whereas it
correctly returns the table comment as REMARK data for Oracle.

I know how to use mySQL's information_schema to get exactly what I need.
But I was hoping to do this in a, well, DBI (Data Base Independent) way.
(I'm aware that mySQL is standard conformant in this area, but Oracle
isn't.)

Am I out of luck? Or is there something I'm missing about the use of
table_info? Should I work on a patch for the mySQL DBD module? Thanks
for any advice, and thanks for mySQL.

Oliver Jones


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org