fpaul,
Wednesday, September 11, 2002, 11:00:56 AM, you wrote:
faadn> I have a problem with the command ALTER TABLE.
faadn> For example, this simple table "test" :
faadn> +-+---+--+-+-++
faadn> | Field | Type | Null | Key | Default | E
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
Maybe it is because some of your id are bigger than 127 wich is the limit
for the Tinyint and when it is converted to this type, "127" is replacing
all your id bigger than 127. Then you have multiple id with 127.
Regards,
Stephan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
