Trying to edit column...

Oni

Hello,

I have an ID column at the beginning of my table. I want to edit it so that it's auto_increment and can support numbers up to 5 characters.

The code phpMyAdmin tried to execute--

=============
SQL query:

ALTER TABLE books CHANGE id id INT( 11 ) NOT NULL DEFAULT '1' AUTO_INCREMENT

MySQL said: Documentation

#1067 - Invalid default value for 'id'

So I set the default value to 0 but I again get the same error...

Any ideas?

Roger_Ramjet

autoinc can't have a default value cos it IS the default value. So just leave that DEFAULT out of the statement.

Oni

Thanks for the reply!

I left the box blank and now I have this error:

SQL query:

ALTER TABLE books CHANGE id id INT( 5 ) NOT NULL AUTO_INCREMENT

MySQL said: Documentation

#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key

I don't have anything else set as auto-increment. Nothing in the table nor the database...?

Oni

Bump--

dp777

#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key

MySQL is complaining b/c the auto increment must be declared as a key. This should do the trick:
ALTER TABLE books CHANGE id id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY;

Oni

That did the trick--

Thank you!!