I took a CSV file from Excel and imported it into my database. I want to make my id column - primary, auto-increment and not null. I'm doing this from the edit box is Front rather than manually - but any combination of not null, auto increment or primary key give me these errors:
1062 - Duplicate entry '0' for key 1
1075 - Incorrect table definition; There can only be one auto column and it must be defined as key.
Why might this be happening? How can I get this to be auto | primary? Do I have to change it manually?
Thanks for any help...
Also, the default box has a '0'.
