±i®p»Ê wrote:
> 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
>
Like you can see, duplicate entry 127, yo create a primary key, but then
you can insert the same value twice...
---------------------------------------------------------------------
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