At 10:50 AM +0800 1/16/01, Rolf Hopkins <[EMAIL PROTECTED]> 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ª " <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>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 |
| [EMAIL PROTECTED] Computer Consultant |
| http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ |
+-------------------------------------- FBI Special Agent Dale Cooper ---+
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
