Re: fetching the primary key of a table
- From: dan@xxxxxxxxxxxxxxxxxxxxx (Daniel Kasak)
- Date: Sun, 04 May 2008 21:27:41 +1000
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
.
- Prev by Date: Re: Pay no attention to that DBI callback behind the curtain
- Next by Date: Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin
- Previous by thread: Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin
- Next by thread: RE: Unable to install DBD::ODBC on OSX Leopard 10.5.2
- Index(es):
Relevant Pages
|
|
