how do you change mysql table properties

[dunskii]

Hi there,

I am trying to change a table that is already indexed.

i tried: ALTER TABLE TableName Modify IntField INT NOT NULL AUTO_INCREMENT;

but it says: there can only be one auto column and it must be a key

I havent set a key or another auto column

thanks for all your help

dunskii

 

[gerrygerry]

Not enough info to help you, show us the all of the existing table's properties and I can help. -gerrygerry
Go To

http://quickfreewebsite.com!

 

[AnakinPt]

ALTER TABLE TableName Modify IntField INT NOT NULL AUTO_INCREMENT PRIMARY KEY;


Anikin
Hugo Alexandre Dias
Web-Programmer
anikin_jedi@hotmail.com