Question marks in phpmyadmin

[Dolemite50]

Hello,

I have a table that shows question marks as a column in mysql. I assume that this is from not setting an index? If so,..is it too late to create a new column and make it auto-increment? That's to say, will it go back and number all the previous entries automatically?

Thanks.

[Drakla]

You can create an auto increment column any time - if you've got any primary keys you'll have to drop them first, then you can use alter table to add a new column and make it auto_increment not null primary key, or even modify an existing column if it hasn't got any duplicates with

alter table killthis modify stockid int unsigned auto_increment primary key not null;