List:General Discussion« Previous MessageNext Message »
From:Steve Edberg Date:January 16 2001 3:09am
Subject:Re: Would you please tell me....
View as plain text  
At 10:50 AM +0800 1/16/01, Rolf Hopkins <rhopkins@stripped> wrote:
>…s¶~ß÷º÷, *\„þµoƒ] (Sorry, not sure of
> some of the characters)
>
>My guess is you have an autoincrement column and it may have gotten screwed
>up.  Try repairing your tables with myisamchk.
>
>Cheers
>
>Rolf


Another possibility -

Do you have a TINYINT column declared as auto increment? A signed 
tinyint's range is only -128 to 127. If so, ALTER that column to 
integer or even unsigned integer.

If this isn't the problem or you don't understand, show us the output 
of a 'describe mymp3' command.

	- steve



>----- Original Message -----
>From: "±iÆpª " <fognming@stripped>
>To: <mysql@stripped>
>Sent: Monday, January 17, 2000 9:59
>Subject: Would you please tell me....
>
>
>Hi,  happy new year!!
>
>Yesterday morning,  I  operated  MySQL  (3.23.28) insert  some data  into a
>table ,
>I found  a  error and  could not find any one can help with:
>............................................................................
>......................................................
>Welcome to the MySQL monitor.  Commands end with ; or \g.
>Your MySQL connection id is 117 to server version: 3.23.28-gamma
>
>Type 'help;' or '\h' for help. Type '\c' to clear the buffer
>
>mysql> use gon;
>Database changed
>mysql> insert into mymp3 (myclass)values('class_four');
>ERROR 1062: Duplicate entry '127' for key 1
>mysql>
>............................................................................
>......................................................
>Could you please tell me what's wrong with and how to deal wiht it ?
>Thanks!!
>
> fongming  from Taiwan  ,2001/1/15
>

+--- "They've got a cherry pie there, that'll kill ya" ------------------+
| Steve Edberg                           University of California, Davis |
| sbedberg@stripped                               Computer Consultant |
| http://aesric.ucdavis.edu/                  http://pgfsun.ucdavis.edu/ |
+-------------------------------------- FBI Special Agent Dale Cooper ---+
Thread
Would you please tell me....張峰銘16 Jan
  • Re: Would you please tell me....Rolf Hopkins16 Jan
    • Re: Would you please tell me....Steve Edberg16 Jan
  • Re: Would you please tell me....mysql16 Jan