popcop
12-10-2004, 07:19 AM
im in my phpadmin and im trying to add auto increment to my ID field but i keep gettin this error
SQL-query:
ALTER TABLE `poll` CHANGE `id` `id` INT( 11 ) AUTO_INCREMENT
MySQL said:
#1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key
whats goin wrong
SQL-query:
ALTER TABLE `poll` CHANGE `id` `id` INT( 11 ) AUTO_INCREMENT
MySQL said:
#1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key
whats goin wrong