I'm brand new to using MySQL. We setup a simple table with 8 fields. The primary key was not setup as an autonumber. The primary key was setup initially for the title field, which we want to setup now an id field as an autonumber.

We when try to insert the id field as the primary key it doesn't show in the table. Can anyne offer any help or suggestions on what might be causing the id field to not show up?

Thanks for any help.
-Dman100-

show us how you are attempting to alter the table to add this column.

Problem fixed...
Just exported to an Access db and added the id field set to the primary key and then re-exported to MySQL.
-Dman100-