List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 19 2000 10:15pm
Subject:Re: error : Duplicate entry for key 1
View as plain text  
At 12:40 PM +0530 12/19/00, Rama Krishna wrote:
>Hi,
>
>     I got a problem while inserting the primary key in a table, for 
>which AUTO_INCREMENT was given.
>I'am using MySQL Database with Perl using DBI module ;
>
>Table was created using the following ..
>
>CREATE TABLE user (
>        id        BIGINT        UNSIGNED        AUTO_INCREMENT    PRIMARY KEY,
>        name   varchar(20)
>) ;
>
>Below is the table structure...
>------------------------------------------------------------------------------------------------------------
>Field                Type             Null        Key        Default 
>Extra
>------------------------------------------------------------------------------------------------------------
>id                    bigint(20)                    PRI            0 
>auto_increment
>name                varchar        YES                       NULL
>
>-------------------------------------------------------------------------------------------------------------
>
>
>After the value of "id" reached 256, and while inserting, the 
>following error message was encountered.
>
>Duplicate entry '256' for key 1
>
>
>The code written was as following ;
>
>######## code starts here  #################
>
>my $dbh = DBI->connect( $dsn, $db_user, $db_pass ) ;
>##  $dsn is data sourse name, $db_user is username, $db_pass is password ###
>
>$qry = "insert into user values( last_insert_id( uid ), 'name')";

What is the function of "uid" here?  You don't have any such column
in your table.

It's not clear what you expect this query to do.

>
>my $RS     = $dbh->prepare( $qry ) ;
>
>if ( ! $RS ) {
>             print "Unable to run query : " . $dbh->errstr ;
>             exit( 0 ) ;
>}
>
>if ( ! $RS->execute() ) {
>             print "Unable to execute query : " . $RS->errstr ;
>             exit( 0 ) ;
>}
>
>######### code ends here #################
>
>Is the problem with "last_insert_id" or "AUTO_INCREMENT" or the way 
>of executing the query ???
>
>Please reply....
>
>Rama Krishna


-- 
Paul DuBois, paul@stripped
Thread
error : Duplicate entry for key 1Rama Krishna19 Dec
  • Re: error : Duplicate entry for key 1Paul DuBois19 Dec