What's the error?
Do you already have an auto-inc field?
Have you tried it with another interface? Ie: directly in the MySQL command
Notes from MySQL.com:
There can be only one AUTO_INCREMENT column per table, and it must be
When you add an AUTO_INCREMENT column, column values are filled in with
sequence numbers for you automatically. You can set the first sequence
number by executing SET INSERT_ID=# before ALTER TABLE or using the
AUTO_INCREMENT = # table option. See section 5.5.6 SET Syntax.
With MyISAM tables, if you don't change the AUTO_INCREMENT column, the
sequence number will not be affected. If you drop an AUTO_INCREMENT column
and then add another AUTO_INCREMENT column, the numbers will start from 1
"Daniel Broome" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am trying to add auto increment to a table I have already created in
> phpMyAdmin but I keeps coming up with an error.
> what can I do to fix this?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php