[prev in list] [next in list] [prev in thread] [next in thread] 

List:       dbi-users
Subject:    fetching the primary key of a table
From:       "jagdish eashwar" <jagdish.eashwar () gmail ! com>
Date:       2008-04-30 16:12:06
Message-ID: f1e12d440804300900vbe928b5m58e8934adb530cb8 () mail ! gmail ! com
[Download RAW message or body]


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?


[prev in list] [next in list] [prev in thread] [next in thread]