changing field properties

[dunskii]

Hi there,

I'm still new to mysql and was wondering the best way to change the field properies.

I want to change a field so it is an auto-increment id

thanks in advance

dunskii

 

[piti]

if u already have an autoincremented column in your table, then u cannot have another one

if the field u want to be auto incremented and it's not one of the tables indexes use this query:

ALTER TABLE TableName Modify IntField INT NOT NULL AUTO_INCREMENT, ADD INDEX (IntField);

if the column is already indexed try this

ALTER TABLE TableName Modify IntField INT NOT NULL AUTO_INCREMENT;

hope this helps

 

[dunskii]

i'm 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

 

[piti]

well the answer is in the error message ;-)

either you already have an auto_incremented column in your table
or
your table is indexed, but not on the column you are trying to modify for auto_incrementation (IntField), this column must have an index, therefore use the other query, with "add index()" statement