Thanks Stephan for your answer but the error message would be : "ERROR 1062:
Duplicate entry '255' for key 1".
I tried to drop the key : "ALTER TABLE test DROP PRIMARY KEY" but I had this
message : "ERROR 1075: Incorrect table definition; There can only be one auto
column and it must be one auto column and it must be defined as a key". So I
can't drop primary key and i can alter my primary key wih the keyword "PRIMARY
KEY" !!...
I think it's not a personnal problem but a limitation (or bug) of MySQL...
Florent.
---------------------------------------------------------------------
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