On Wed, 2008-04-30 at 21:30 +0530, jagdish eashwar wrote: > Hi, > When I use the following syntax with Oracle, I am able to retrieve the > primary key. But the same syntax doesn't seem to work with MySql. > > @primary_key = $dbh->primary_key($catalog,$schema,$table); > > With my Oracle database, this translates to: > @primary_key = $dbh->primary_key(undef,'JAGDATA_TRANSFER','ORIG'); > > With my MySql database, this translates to: > @primary_key = $dbh->primary_key(undef,'jagdata_transfer','orig'); > > What am I doing wrong?
I use: $dbh->column_info( undef, $schema, $table, '%' ); Dan
